Syntax for defining dynamic column range

[mwc0914]

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?

[mgs73]

This should work: Set report = Range(Columns(1), Columns(lastcolumn))