Carin
Board Regular
- Joined
- Feb 4, 2006
- Messages
- 224
When running the macro below, it works great if the last time I used Ctrl + F and selected Entire Workbook. But if I have just worksheet selected, the macro only runs on one sheet.
How can I change the macro so it will always run throughout the workbook no matter how I have my Ctrl + F selected from a previous search?
Cells.Replace What:=":", Replacement:="", LookAt:=xlPart, SearchOrder:= _
xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
Range("A1").Select
How can I change the macro so it will always run throughout the workbook no matter how I have my Ctrl + F selected from a previous search?
Cells.Replace What:=":", Replacement:="", LookAt:=xlPart, SearchOrder:= _
xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
Range("A1").Select