GSxMuscleMlk
New Member
- Joined
- Dec 8, 2021
- Messages
- 1
- Office Version
- 365
- 2021
- 2019
- 2016
- Platform
- Windows
I'm newer to VBA and have been trying to combine the various parts of this request with no luck.
To summarize:
VBA to run on click
1st function - ask user how many rows to be added and allow an input (0-999)
2nd Function - find the last used row in the data and insert the specified number of rows from 1st function
3rd function - in the newly added rows, copy from a specific row which contains formulas and paste formulas in all new rows
End.
Final result should provide new rows with prepopulated formulas from a specific range.
The Range that has formulas, i'd like to enter this in an unused part of the worksheet, say row 200 and specify what formulas will be paste in each new row.
To summarize:
VBA to run on click
1st function - ask user how many rows to be added and allow an input (0-999)
2nd Function - find the last used row in the data and insert the specified number of rows from 1st function
3rd function - in the newly added rows, copy from a specific row which contains formulas and paste formulas in all new rows
End.
Final result should provide new rows with prepopulated formulas from a specific range.
The Range that has formulas, i'd like to enter this in an unused part of the worksheet, say row 200 and specify what formulas will be paste in each new row.