Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and Replace
I have a macro that I use to replace the contents of cells on a
worksheet which have a comment attached with an "F" in the cell (in place of an asterisk "*"). It works fine most of the time but at times when I run it fails miserably changing the contents of all non- blank cells in the workbook to "F". It seems that it does this because the "within" setting in my Find and Replace wizard has been set to "Workbook" rather than "Sheet" prior to running the macro. The relevant lines of code in my macro (which were recorded) are Selection.SpecialCells(xlCellTypeComments).Select Selection.Replace What:="*", Replacement:="F", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False I surmised that the LookAt:=xlPart was the bit of code that should set the search to sheet only, but it doesn't seem to be doing what I think it should be doing. I guess this is probably a quite simple thing, but if someone could help me resolve it it would be appreciated. TIA Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
Find/Replace Event or Find/Replace for Protected Sheet ... | Excel Programming | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Using Find and Replace to replace " in a macro | Excel Programming | |||
Replace method - cannot find any data to replace | Excel Programming |