Hi, I am having problems finding and replacing dates..
I hit Ctrl H and enter the date to find then go to options to set the format and still the date couldn't be found, is there another way??
Hi, I am having problems finding and replacing dates..
I hit Ctrl H and enter the date to find then go to options to set the format and still the date couldn't be found, is there another way??
Paul
Here's a find and replace macro, the main problem is probable the formatting in the find. in find and replace form hit the options button and select the format you are looking for, anyway here is the macro,
This code searches for the value in range A1 and its format, then replaces it with the value in B1![]()
Sub Macro1() ' Macro1 Macro ' Macro recorded 8/11/2007 by David Morrison Application.FindFormat.Clear Application.FindFormat.NumberFormat = "m/d/yyyy" Cells.Replace What:=Range("A1"), Replacement:=Range("B1"), LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=True, _ ReplaceFormat:=True End Sub
Cool,
Works just as you say
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks