How do I define a Dynamic Selection Range so that the endpoint is at the last row of data?
I'm trying to copy a formula to all occupied rows using the AutoFill feature.
Having selected the cell (N2),this is what I'm looking to use: 'Selection.AutoFill Destination:=Range("N2:N???")' where the ??? represent the last row.
I will use this macro repeatedly on files with a variable number of rows.
Hints, help, suggestions appreciated.
Frank