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:
ActiveWindow.ScrollRow = *
but it couldn't find any results. Does anyone know a better way than just manually deleting each line?
Bookmarks