I want to define a range of columns, but the number of columns may vary each time I run my macro.
I have determined how many columns I have, so I need the proper syntax for the SET statement when the ending column definition can vary.
I may have something like this...
lastcolumn = 11 (this value will vary)
Dim report as Range
set report = Range ("a:" & lastcolumn) <---- what is correct syntax for this statement in this case?
Bookmarks