View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GB GB is offline
external usenet poster
 
Posts: 230
Default 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