Thanks Tarwn,
Much of that is what I was doing to find the last row of the range. The problem was was in the syntax of the code with reference to the objects that I was using. After further study, the code below works.
Sub Auto_Open
ThisWorkbook.Sheets("Demographics").Activate...
I have a combo box in a worksheet that displays the names and numbers of a list of healthcare providers. I initially typed the range into the properties dialog for that combobox. Whenever new providers are added to the provider list, I need a macro to determine the new range and...
Hi VJay,
You could have the user input the Row numbers into a cell. For example A1 will contain the starting Row number and A2 will contain the ending row number. Once the numbers are in the cell, you can build the reference.
Set lnStartRow = Range("A1").Value
Set lnEndRow =...