| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to select current sheet tab
Thanks to all of you I learned a lot! For my purposes this worked:
Dim i As Long For i = 1 To 26 Sheets(i).Name = Sheets(i).Range("a1").Value Next i thanx again "Gord Dibben" wrote: Jim Are you in B.C.? Gord On Tue, 6 Mar 2007 14:01:18 -0800, Jim Thomlinson wrote: Look... Gord is Fancy too... It must be a British Columbia thing. Perhaps something in the salt air... <bg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function To Select the Hidden Rows & Columns in the Current Sheet | Excel Discussion (Misc queries) | |||
| Select Current Row | Excel Programming | |||
| how to select current range | Excel Programming | |||
| Select current region and print | Excel Programming | |||
| Select current region less one column | Excel Programming | |||
Threaded Mode
