VBA issue with Replace

[cstimart]

I am using the following line

Range("O2:U" & LR).Replace What:="", Replacement:=#12/31/3099#, LookAt:=xlWhole

It's filling EVERY empty cell in the "used range" (which is A1:Z19257) with the 12/31/3099 date.

What am I missing?

 

[venkat1926]

it will
you are searching for cell having "" that means blank cells.

which cell do you want to replace. specify.

 

[RoryA]

Try:

With Range("O2:U" & LR)
   .Find what:="*"
   .Replace What:="", Replacement:=#12/31/3099#, LookAt:=xlWhole
end with