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

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

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