| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing previous page
Hello NG,
I'm having a problem accessing the previous page from code. By that I mean every couple of days or once a week I add a page, through a macro, and then I need to go to the previous page (different name every time) and copy everything in the E column and then return to the last page (also different name every time) and paste the copied numbers in Column I. I know how to get the page count but I don't know how to use the count after I get it. Any suggestions please. TIA James |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing previous page
Previous page:
Worksheets(ActiveSheet.Index - 1) Last page: Worksheet(Worksheets.Count) -- Vasant "James Agostinho" wrote in message ink.net... Hello NG, I'm having a problem accessing the previous page from code. By that I mean every couple of days or once a week I add a page, through a macro, and then I need to go to the previous page (different name every time) and copy everything in the E column and then return to the last page (also different name every time) and paste the copied numbers in Column I. I know how to get the page count but I don't know how to use the count after I get it. Any suggestions please. TIA James |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing previous page
"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... Previous page: Worksheets(ActiveSheet.Index - 1) or activesheet.previous.select |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing previous page
Thanks, it seems too simply, but works great for what I want.
James "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... Previous page: Worksheets(ActiveSheet.Index - 1) Last page: Worksheet(Worksheets.Count) -- Vasant "James Agostinho" wrote in message ink.net... Hello NG, I'm having a problem accessing the previous page from code. By that I mean every couple of days or once a week I add a page, through a macro, and then I need to go to the previous page (different name every time) and copy everything in the E column and then return to the last page (also different name every time) and paste the copied numbers in Column I. I know how to get the page count but I don't know how to use the count after I get it. Any suggestions please. TIA James |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3-Color Scale Vlookup for Current Month/Previous/Pre-Previous | Excel Discussion (Misc queries) | |||
| Borders from previous page showing up at top of new page | Excel Discussion (Misc queries) | |||
| Reference previous page | Excel Worksheet Functions | |||
| continue page numbers from previous worksheet | Excel Discussion (Misc queries) | |||
| Running Total from previous page | Excel Worksheet Functions | |||
Linear Mode
