| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Navigate Sheets - better way.
I want to navigate from one sheet to the other. Is there a better way then
this.... ' Go back and format previous sheet. Sheets(Worksheets.Count - 1).Select ' Format sheet. Call SB2_Format ' Come back and start again. Sheets(Worksheets.Count).Select |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Navigate Sheets - better way.
activesheet.previous.select
SB2_Format ActiveSheet.Next.Select Not sure if it makes any difference. Another approach would be to modify SB2_format so you can pass a sheet reference to it and it can format that sheet without activating it. then the code could just be set sh = Activesheet.Prevous SB2_Format sh -- Regards, Tom Ogilvy "Doug929" wrote in message ... I want to navigate from one sheet to the other. Is there a better way then this.... ' Go back and format previous sheet. Sheets(Worksheets.Count - 1).Select ' Format sheet. Call SB2_Format ' Come back and start again. Sheets(Worksheets.Count).Select |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Navigate Sheets - better way.
Thanks Tom, you have been helping for years! I appreciate it.
"Tom Ogilvy" wrote: activesheet.previous.select SB2_Format ActiveSheet.Next.Select Not sure if it makes any difference. Another approach would be to modify SB2_format so you can pass a sheet reference to it and it can format that sheet without activating it. then the code could just be set sh = Activesheet.Prevous SB2_Format sh -- Regards, Tom Ogilvy "Doug929" wrote in message ... I want to navigate from one sheet to the other. Is there a better way then this.... ' Go back and format previous sheet. Sheets(Worksheets.Count - 1).Select ' Format sheet. Call SB2_Format ' Come back and start again. Sheets(Worksheets.Count).Select |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Navigate in a big worksheet | Excel Discussion (Misc queries) | |||
| Ctrl+Page Down to navigate sheets | Excel Discussion (Misc queries) | |||
| Navigate by macro | Excel Programming | |||
| Macro to navigate between sheets | Excel Programming | |||
| Use list box to navigate to different sheets... | Excel Programming | |||
Linear Mode
