How to Clean Recorded Macro

[jomili]

I often use the macro recorder to record a macro, and since I work on huge worksheets I wind up with a lot of "ActiveWindow.ScrollRows..." lines, which I then go and manually delete. I figured someone would have some type of automated routine to clean up this code without having to do it manually, and have looked for it online with no luck. I tried a "Replace" by putting this in the "Replace" field:

Please Login or Register  to view this content.

but it couldn't find any results. Does anyone know a better way than just manually deleting each line?

[protonLeah]

Please Login or Register  to view this content.

[jomili]

ProtonLeah, Sorry it's taken me so long to reply; our email has been flaky, and wouldn't accept email from anyone outside our agency since Monday, so I just go the reply today. I tried using the string you posted, and got a "not found" when I tried a "Replace". Any other ideas?

[jomili]

Bumping up, still in need of a solution.

[jomili]

Bumping up again.

[jomili]

And once more.

[shg]

Tick Use Pattern Matching

[jomili]

A-ha! The lightbulb turns on! So instead of simply putting

Please Login or Register  to view this content.

in my "Find What" field, I need to also check off the "Pattern Matching". Pretty easy once you know how.

Thanks so much!