I have a worksheet which contains formulas and validations in Row 5. If a user needs to insert rows, I'd like to prompt them to ask them "how many rows would you like to insert?" and then insert the requested number of rows below Row 5. I would then like to copy all of Row 5 and paste into the inserted rows and then clear the contents from the inserted rows. Is this possible? Any help much appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA Help inserting client specified number of rows and copy and paste from Row 5
- Thread starter ASanders
- Start date
-
- Tags
- insert rows macro prompt user vba
