Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Little problem with the REPLACE method.
I 'm sure someone has had this problem before.
(It's very similar to a problem I had with the Find method that was solved in an earlier thread) Column C is a column of dates, and is formatted as "14-Mar-98". Some of the cells in column C contain, in integer form, 0 (zero): and are therefore returning "0-Jan-00" in the above format. Therefore why does the below code NOT replace the values in these cells! (the below doesn 't seem to throw an error either which is sort of strange) I got the below code from the macro recorder and then just changed xlPart to xlWhole. Columns("C:C").Select Selection.Replace What:="0-Jan-00", Replacement:="n/a", _ LookAt:=xlWhole, SearchOrder:=xlByRows, _ MatchCase:=True any help greatly appreciated Jason |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Little problem with the REPLACE method.
Try replacing What:="0-Jan-00" with
What:= 0 Since that is the actual content of the cell. HTH "jase" wrote in message oups.com... I 'm sure someone has had this problem before. (It's very similar to a problem I had with the Find method that was solved in an earlier thread) Column C is a column of dates, and is formatted as "14-Mar-98". Some of the cells in column C contain, in integer form, 0 (zero): and are therefore returning "0-Jan-00" in the above format. Therefore why does the below code NOT replace the values in these cells! (the below doesn 't seem to throw an error either which is sort of strange) I got the below code from the macro recorder and then just changed xlPart to xlWhole. Columns("C:C").Select Selection.Replace What:="0-Jan-00", Replacement:="n/a", _ LookAt:=xlWhole, SearchOrder:=xlByRows, _ MatchCase:=True any help greatly appreciated Jason |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Little problem with the REPLACE method.
Thanks
I'll give that a go J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using SaveAs method | Excel Discussion (Misc queries) | |||
VBA in Microsoft Excel: Find & Replace method macro across multiple files | Excel Programming | |||
Problem with find method | Excel Programming | |||
InputBox Method Logic Problem | Excel Programming |