arrange windows vertically - 2 selected sheets

  • Thread starter Thread starter al007
  • Start date Start date
A

al007

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
 
I manage to do the 2nd situation can anybody help with the 1st
ie current active sheet & a selected sheet

thxs
 
Using the macro recorder...........


Sheets("Sheet1").Select
Range("C25").Select
ActiveWindow.NewWindow
Sheets("Sheet2").Select
ActiveWorkbook.Windows.Arrange ArrangeStyle:=xlVertical
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How many sheets open? 5
Rename sheet with (2) after existing name of existing sheet 3
Grouped Sheets - Windows Arrange 8
Array code only works on selected sheet 14
Run Macro on All Sheets Q 8
Macro to Compile Data from Different Sheets 2
Check - Similar Row contents - Different Sheets 4
Rename active sheet with current file name 5

Back
Top