| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA question about selecting worksheets | Excel Discussion (Misc queries) | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| Yet another Newby question about selecting | Excel Programming | |||
| Beginner question about selecting a range | Excel Programming | |||
Threaded Mode
