title: Find and Replace whole Workbook in VBA without loop?
body: <p>Using the build in Find&amp;Replace function in Excel and setting it to search in the whole workbooks works much faster that using VBA and searching each worksheet though a loop. When I record the macro it only give me VBA code that goes though the active sheet and not the whole workbook. Is there a VBA solution that works just as fast as the build in function?</p>