Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with using variable in Find statement
I am writing a macro to locate the current date (in form mm/dd/yy) from a
column of dates in column A1. I am using a variable that is set to the value of cell G1 that uses the NOW function to return the current date. However, the Find method does not seem to like a variable. Below is the code I am currently using to locate the current date. When I run this I get an error, please help! Dim LookFor LookFor = Range("G1").Select Range("A1").Select Cells.Find(What:=LookFor, After:=ActiveCell, LookIn:=xlValues, LookAt _ :=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=_ False).Activate |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable in if statement | Excel Worksheet Functions | |||
if than statement has too many variable | New Users to Excel | |||
Macro Creating Variable and using variable in a SQL statement | Excel Programming | |||
Cells.Find error Object variable or With block variable not set | Excel Programming | |||
Problem trying to us a range variable as an array variable | Excel Programming |