Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
windows.sheets ?
Hello,
I've got 2 windows of the same sheet (same workbook) This is the way excel gives you the top, the middle and the bottom of a same sheet. When I scroll the columns, and select an other window, it foolows the scroll: with ActiveWorkbook ..windows(1).ScrollColumn = .windows(2).ScrollColumn end with this works fine. The point is my workbook doesn't have only one sheet, and I would like to access the right one ! (of course) I need something like: .windows(i).scrollcolumn(of sheets1) or: .windows(i).Sheet1.scrollcolumn of course, this is not a known syntax ! it only knows windows.activesheet Excel has got the data (the scrollcolumn of sheet1 in the window(i) ) inside its head, how do I get it ? -- dc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
windows.sheets ?
Sub ActivateSheet()
Dim wb As Workbook Dim ws As Worksheet Set wb = ThisWorkbook Set ws = wb.Sheets(1) ws.Activate End Sub "David C." schreef in bericht ... Hello, I've got 2 windows of the same sheet (same workbook) This is the way excel gives you the top, the middle and the bottom of a same sheet. When I scroll the columns, and select an other window, it foolows the scroll: with ActiveWorkbook .windows(1).ScrollColumn = .windows(2).ScrollColumn end with this works fine. The point is my workbook doesn't have only one sheet, and I would like to access the right one ! (of course) I need something like: .windows(i).scrollcolumn(of sheets1) or: .windows(i).Sheet1.scrollcolumn of course, this is not a known syntax ! it only knows windows.activesheet Excel has got the data (the scrollcolumn of sheet1 in the window(i) ) inside its head, how do I get it ? -- dc |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
windows.sheets ?
well, this does not reply to the question at all...
wrong message ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I unstack multiple spread sheets in Windows XP? | Excel Worksheet Functions | |||
different sheets in separated windows | Excel Discussion (Misc queries) | |||
viewing two spead sheets in two separate windows | Excel Discussion (Misc queries) | |||
Consolidating Excel sheets within Office Binder in Windows 2000 | Excel Discussion (Misc queries) | |||
Grouped Sheets - Windows Arrange | Excel Discussion (Misc queries) |