Is there macro that can scroll to a date in a column?

[tonywatsonhelp]

Hi Everyone,


I have a sheet with this years calendar in it (so you can imagine it 365 columns wide

I row1 I have the dates Start In Column G with 01/01/2017 and go up one day at a time across the page to give me my calendar

in A2 in Have todays date

hat Id like is a macro that when I select the sheet (on activate!) it automaticly takes me to row 1 and the todays date?

Any ides how this can be done?

Please help thanks

Tony

 

[JLGWhiz]

goes in sheet code module.

Private Sub Worksheet_Activate()
 Range("1:1").Find(Date, , xlValues).Select
End Sub

You might prefer this

Private Sub Worksheet_Activate()
 Range("1:1").Find(Date, , xlValues).Select
 ActiveWindow.ScrollColumn = Selection.Column
End Sub

 

[tonywatsonhelp]

Thanks JLG Whiz

this is great

Thanks

 

[JLGWhiz]

Thanks JLG Whiz

this is great

Thanks

You're welcome,
regards, JLG

 

[jim may]

In your second Macro, If I substitute the following below -- I get an code-error RT 91 -- Why?

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim Rng As Range
Cancel = True
Set Rng = Range("G1:NG1")
With Rng
    .Find(Range("G$2").Value, , xlValues).Select
    ActiveWindow.ScrollColumn = Selection.Column
End With
End Sub

 

[JLGWhiz]

In your second Macro, If I substitute the following below -- I get an code-error RT 91 -- Why?

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim Rng As Range
Cancel = True
Set Rng = Range("G1:NG1")
With Rng
    .Find(Range("G$2").Value, , xlValues).Select
    ActiveWindow.ScrollColumn = Selection.Column
End With
End Sub

don't know, Jim. I cannot duplicate the error. It works as expecdted for me. Is there something in your worksheet (or not in your sheet) that would prevent the variable from setting? Does the target value exist?