Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When a user saves a workbook, you can not trust the user to save while
residing in a preferred sheet. Nor can you trust that the sheets will always have the same name as the previous workbook. I need some code that will move my VB process to the first sheet, or leftmost, sheet in the workbook. Something along the lines of; Activesheet.Next.Select or Activesheet.Previous.Select but the problem is, I don't know how many sheets could possiblely be in the workbook or what sheet the cursor was on when the workbook was last saved. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select number from leftmost column that has one | Excel Discussion (Misc queries) | |||
leftmost number value | Excel Discussion (Misc queries) | |||
vlookup- is a must that lookup value should be the leftmost colum? | Excel Discussion (Misc queries) | |||
Delete rows with specific leftmost value | Excel Programming | |||
Leftmost and Rightmost Cell | Excel Programming |