SelinaR
Board Regular
- Joined
- Feb 2, 2012
- Messages
- 65
- Office Version
- 2021
- Platform
- Windows
- Mobile
- Web
Hiya
I have a current Macro that finds a date....
Sub searchdate()
Dim i, lr As Integer
lr = ActiveSheet.Range("A65536").End(xlUp).Row
For i = 3 To lr
If Cells(i, 1) = Date Then
Cells(i, 1).Select
Exit For
End If
Next i
End Sub
However I have a spreadsheet that I need to only find the current month that I am in - Column B is the column that hold each month heading from 2010.
EG: Jan-2010
Is there a "Go to" function, a formula or a Macro possible to do this - as I've attempted to manipulate the above Macro and it's not working
![Mad :mad: :mad:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
THANKS
I have a current Macro that finds a date....
Sub searchdate()
Dim i, lr As Integer
lr = ActiveSheet.Range("A65536").End(xlUp).Row
For i = 3 To lr
If Cells(i, 1) = Date Then
Cells(i, 1).Select
Exit For
End If
Next i
End Sub
However I have a spreadsheet that I need to only find the current month that I am in - Column B is the column that hold each month heading from 2010.
EG: Jan-2010
Is there a "Go to" function, a formula or a Macro possible to do this - as I've attempted to manipulate the above Macro and it's not working
THANKS