Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving to Next Sheet
Hi-
I am having trouble coming up with code to move to the next sheet. The problem is the code I have is based on the Sheet# (Sheet1, Sheet2, etc). The user may re-name these sheets and move them around the workbook. How do I code it so it always starts on worksheet 3, and then loops to the next worksheet REGARDLESS OF WHAT NUMBER THE SHEET IS? (Note: Sheets 1 & 2 are directions sheets and will always be there....that is why I want to start with Sheet 3.) The code I have now is this and it is not working properly: Sheets(ActiveSheet.Index + 1).Select Thanks In Advance! -Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for moving information from one sheet to another sheet | Excel Discussion (Misc queries) | |||
moving from one sheet to another from a cell of a sheet | Excel Worksheet Functions | |||
Moving to a new sheet. | Excel Worksheet Functions | |||
moving informatiion from one sheet to a total sheet | Excel Discussion (Misc queries) | |||
Moving from one sheet to another | Excel Discussion (Misc queries) |