Selecting range question
I have the following code to select a range:
Sheets("TEST").Select
Range("A1:F129").Select
Is there a way to select this range WITHOUT first
selecting the sheet? I'd like to speed up my macro and
thought this would be a good place to start.
I tried:
Sheets("TEST").Range("A1:F129")
and I get an error.
TIA, Todd
|