1) issue number one-

Im using

ctr = Range("B2", Range("B2").End(xlDown)).Count

to determine the number of rows of data that is used in a excel sheet.

below are the columns that are used in the sheet.

start date, end date, greater than 90 days( this column is inserted by me)

the greater than 90 days just calculates the difference between the start date and the end date. depending on the number of rows, i want the macro to calculate dynamically till the last row only for the - greater than 90 days column. How can i do this? Is it possible to set the range to the cell B2??

2) the sheet that i am working on is not standardized. so the fields that i require may be located in different columns.
for example in one sheet, the start date might be in column A, in another sheet the start date might be in column B.
Is it possible to create a macro using the name instead of the cell? How can this be done.