It should be like this
or![]()
Dim sinMonth As Single sinMonth = Month(Date) Select Case sinMonth Case 1 Application.Goto Sheets("Jan").Range("E5") Case 2 Application.Goto Sheets("Feb").Range("E5") Case 3 'etc Case Else Exit Sub End Select
![]()
Select Case Month(Date) Case 1 Application.Goto Sheets("Jan").Range("E5") Case 2 Application.Goto Sheets("Feb").Range("E5") Case 3 'etc Case Else Exit Sub End Select
Bookmarks