find day
Sure. Record yourself doing a Find operation, and in the macro, replace the
text string with a cell reference, like so:
Sub FindMe()
'Change the What:=Range(XX).value to match your cell
Cells.Find(What:=Range("A1").Value, After:=Range("A1"), _
LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
End Sub
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Sj" wrote:
I have a workbook that in the first sheet is daily data that changes and the
rest of the sheets relate to a day in the month, I want to be able to type in
todays date in the first worksheet (A1) and then run a macro to go to that
day, is this possible?
any help appreciated.
|