Hi there,
I'm trying to use the following Macro for an "Add 10 Rows" button - I need a button that will copy ten specially formatted rows and paste the special formatting.
Two things I'm hoping someone can fix on this script:
1. The rows need to paste after the last used active row, not necessarily in the range 35:44 as shown below.
2. Will it be affected if I remove the scroll?? Currently, when I click the button, my document blinks as it "scrolls down" and "scrolls up" again.
Here it is...
Really, really appreciate any help - this is for a huge work document.
Thanks.
Bookmarks