Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Designating Sheet vs Workbook When Doing Find/Replace
This code is suppose to remove excess spaces from the specified range.
However, it sometimes thinks I mean to do this within the entire workbook, versus the range on the specified sheet. Have not been able to figure out how to adjust this so that it knows to only do this within a specific range. Can someone please help? Worksheets("MMS for CP").Range(Range("G3"), Range("G65536").End(xlUp)).Select Selection.Replace What:=" ", Replacement:="", LookAt:=xlPart, SearchOrder _ :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find/Replace Event or Find/Replace for Protected Sheet ... | Excel Programming | |||
find replace within sheet or workbook | Excel Programming | |||
find and replace within workbook macro | Excel Discussion (Misc queries) | |||
Designating a workbook reference base on a cells contents | Excel Worksheet Functions | |||
find and replace, within workbook | Excel Discussion (Misc queries) |