Copy & Paste Macro only works when grouped cells are expanded?

Hi there,

I have a project management spreadsheet that I've created to keep track of all of my projects. For each project is a checklist. I've created a macro (with the help of you guys) that copies an empty project template (that includes the header and checklist underneath) from one sheet, and pastes it in another under my current projects (so that none of my previous projects get any rows erased.

The checklist under my project is grouped, so that I can minimize all the project checklists in order to see just the name/location, etc, of all my projects at once. The issue is this: When my checklists are collapsed (for visibility), my macro replaces the checklist of the last project in line, instead of pasting the template 2 rows beneath it. There is absolutely no issue when the checklists are expanded; only when they are collapsed it does this. Here's the macro that you guys helped me create:

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)