thutchinson
asked on
VBA Select Range when rows and columns are dynamic
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(xl LastCell)) .Select
Thanks for your help, Experts!
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(xl
Thanks for your help, Experts!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Quick reply, great answer. in a word, "Perfect!"
ASKER