VBA Select Range when rows and columns are dynamic
Posted on 2012-03-17
I would like to create a macro that will select the range based on the following:
1) Upper left is determined by wherever the curser is placed when the macro is executed.
2) Lower right is determined by last row with data in COL A and last column with a header.
The macro will be executed on the active worksheet in whatever workbook is open.
For example, this code gives me lots of empty records: Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Thanks for your help, Experts!