| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
arrange windows vertically - 2 selected sheets
looking for a general macro which will arrange my current active sheet
& another selected sheet vertically or a less flexible one which would arrange 2 predefined sheets vertically ie sheet1 & shhet 2 only) thxs |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
arrange windows vertically - 2 selected sheets
I manage to do the 2nd situation can anybody help with the 1st
ie current active sheet & a selected sheet thxs al007 wrote: looking for a general macro which will arrange my current active sheet & another selected sheet vertically or a less flexible one which would arrange 2 predefined sheets vertically ie sheet1 & shhet 2 only) thxs |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
arrange windows vertically - 2 selected sheets
Using the macro recorder...........
Sheets("Sheet1").Select Range("C25").Select ActiveWindow.NewWindow Sheets("Sheet2").Select ActiveWorkbook.Windows.Arrange ArrangeStyle:=xlVertical -- Greetings from New Zealand Bill K "al007" wrote in message oups.com... looking for a general macro which will arrange my current active sheet & another selected sheet vertically or a less flexible one which would arrange 2 predefined sheets vertically ie sheet1 & shhet 2 only) thxs |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I arrange tabs vertically in Excel (not horizontally)? | Excel Discussion (Misc queries) | |||
| how do i arrange alphabetically my sheets? | Excel Worksheet Functions | |||
| Grouped Sheets - Windows Arrange | Excel Discussion (Misc queries) | |||
| Arrange Windows | Excel Discussion (Misc queries) | |||
| How to change windows.arrange from xlTiled to xlHorizontal and back in one procedure | Excel Programming | |||
Hybrid Mode
