thepinkbird
New Member
- Joined
- Dec 2, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi all!
I'm new to VBA and have been working on a template. I've found some threads relating to my question but haven't had luck with the code. I'm hoping to reference the cell value on one sheet, and add that number of formatted rows to another sheet.
For example:
Number of rows to add: "Sheet 2, J10"
Where to insert: "Sheet 1, Row 58" formatted the same way as Row 58.
Cell J10 could show a value as high as 50, and the rows it adds would need to be formatted the same way as row 58, including cells being unlocked on a protected sheet.
Thank you for any help you can provide!
I'm new to VBA and have been working on a template. I've found some threads relating to my question but haven't had luck with the code. I'm hoping to reference the cell value on one sheet, and add that number of formatted rows to another sheet.
For example:
Number of rows to add: "Sheet 2, J10"
Where to insert: "Sheet 1, Row 58" formatted the same way as Row 58.
Cell J10 could show a value as high as 50, and the rows it adds would need to be formatted the same way as row 58, including cells being unlocked on a protected sheet.
Thank you for any help you can provide!