I have dates in Column A which are in ascending order and I have:
Sub abc()
x=inputbox("Please input a starting date")
set f =Range("A:A").find(x)
end if
What I want is to find the first row which date is >=x. Please tell me how to write the script. Thanks.
Sub abc()
x=inputbox("Please input a starting date")
set f =Range("A:A").find(x)
end if
What I want is to find the first row which date is >=x. Please tell me how to write the script. Thanks.