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
|