Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a cell with date in it
I am interested in finding a cell with a specific date in it.
I have tried the following without any success. Range("A20").Select CurrentDate = ActiveCell.Value Range("c32.cj32").Select Selection.Find(CurrentDate).Activate Any suggestions would be greatly appreciated. Roger |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a cell with date in it
If nothing else, your second Range select, appears to be incorrectly
formatted. "c32.cj32" doesn't mean anything to the best of my knowledge. It should use a colon "c32:cj32" Might fix your prob. "Roger B." wrote: I am interested in finding a cell with a specific date in it. I have tried the following without any success. Range("A20").Select CurrentDate = ActiveCell.Value Range("c32.cj32").Select Selection.Find(CurrentDate).Activate Any suggestions would be greatly appreciated. Roger |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a cell with date in it
GB, thanks for your help in changing to a colon.
It appears that I need to change my question to one that is more flexible as follows. I am interested in getting a macro to find a cell in row 23 with a specific date in it such as Fri, Jan 27, 06. Any suggestions would be greatly appreciated. Roger "GB" wrote in message ... If nothing else, your second Range select, appears to be incorrectly formatted. "c32.cj32" doesn't mean anything to the best of my knowledge. It should use a colon "c32:cj32" Might fix your prob. "Roger B." wrote: I am interested in finding a cell with a specific date in it. I have tried the following without any success. Range("A20").Select CurrentDate = ActiveCell.Value Range("c32.cj32").Select Selection.Find(CurrentDate).Activate Any suggestions would be greatly appreciated. Roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find a cell with a particular date format? | Excel Discussion (Misc queries) | |||
how to find date and time of each cell ? | Excel Discussion (Misc queries) | |||
select date range then find average of values in another cell | Excel Worksheet Functions | |||
find cell with today's date | Excel Discussion (Misc queries) | |||
macro to find date format in a cell and delete that entire row | Excel Programming |