Worksheet position

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to specify a condition that makes every worksheet within a
workbook open so that the current month column is displayed as the left hand
column. The problem is that the current month column is not the same column
(ie not all C) across the worksheets. I can wrte a little if statement to
say if column header matches Feb but do not know how to say ...Then position
this column as left column.

Can anyone help?

Thanks,

Tom
 
Application.Goto Reference:=Worksheets("sheet1").Range("F1"), _
Scroll:=True

or look at
ActiveWindow.ScrollColumn = 6
ActiveWindow.ScrollRow = 1
 
try this idea
Sub gotomonth()
On Error Resume Next
x = Rows(2).Find(Month(Date)).Column
Application.Goto Cells(1, x), Scroll
End Sub
 
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

Excel 2013 Merge Data 2
Center spreadsheet in middle of window 1
IF Statement based on first two characters of cell 4
Compare two worksheets in the same workbook and highlight difference 7
Problem sorting a range of columns using VBA 1
Find a value in a sheet and replace it with another value if it matches 8
Linking cells between worksheets in same workbook 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top