Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
move.worksheet command
I have a worksheet that is adding data on sheets between two anchor sheets.
When a user wants to examine specific sheets I have an input box asking which sheets they want to look at and then am using the move.worksheet before and after to move my anchor sheets. This works fine usually but when certain sheets, the ones at the beginning of the workbook are chosen after the code is run my totals sheet has had it's formulas changed. usually reads sum(blank:template!a1) to say (january:template!a1) if the january sheet is chosen. Can anyone explain as to why this is happening? Nothing in the code is referencing this page while the code is running. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command to move to different sheet | Excel Worksheet Functions | |||
command buttons disappear when I move worksheet 2007 | Excel Discussion (Misc queries) | |||
VB command to move down one row | Excel Discussion (Misc queries) | |||
command button move worksheet from one workbook to another | Excel Programming | |||
Command to move down one row | Excel Programming |