Find and Replace

[Carin]

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

 

[Sektor]

There's no argument which would let you scan whole workbook (the same problem with so-calle "3D-formulas", i.e. =SUM(Sheet1:Sheet10!A1), which would sum up cells A1 on sheet1 and all sheets through to Sheet10). In this case, you need a loop.