Set a range from a variable location

[Troubled User]

I am using a loop function that will eventually select and activate a
specific cell known as "TheCurrentCell." Once I reach that location I want
to use that coordinate as the upper left area of a new range. Supposing that
the end cell of my range is D1000, the Range selection would be something
like Range(TheCurrentCell1000).select, however, I don't know the correct
syntax to make this happen.

Please help. Thank you.

 

[bpeltzer]

Use something like Range(Selection.Address & "1000").Select.

 

[Troubled User]

Thank you. It worked!!

Use something like Range(Selection.Address & "1000").Select.