Hi all
I'm trying to make part of a macro that will find user input.
User starts macro, is prompted to enter a date, and macro will find the date.
Problem is, the code I've used does not want to work for me.
I've tried Dim/Set, For Each/Next, and the below:
date1 = InputBox("Enter date", "Enter Date")
Cells.Find(What:=date1, After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
Does anyone know what I'm doing wrong, please?
Thank you
Bookmarks