selecting cells based on variables

[Matthew Leggett]

Hi folks I am using Visual Basic script and I need to select a range based on one of the following notation Worksheets(SetMonth).Range($D$8:$D$24).Select StartLocation = "$D$8" EndLocation = "$D$24" Worksheets(SetMonth).Range(" & StartLocation & ":" & EndLocation & ").Select Both of the above seem to work with other formulations however I don't seem to be able to use either of the above to select the range of cells required. Can Anyone help

[Wendelius]

Matthew Leggett wrote:

Worksheets(SetMonth).Range(" & StartLocation & ":" & EndLocation & ").Select

Is that the full code line, since it doesn't make sense. Starting and ending quotation marks don't match. If this is Excel VBA, it would look something like:

Worksheets("SetMonth").Range(StartLocation & ":" & EndLocation).Select