insert blank row and header copy

Looking for a Excel 2007 macro that will do the following:

Loop through data in column C
When the data in column C changes
insert a blank row followed by a row that contains a copy of the header

Other Info:
Single Sheet
Header (Row 2)
Variable Number of rows
100+ columns (A:BZ)

Thank You!

Hello msmick,

Welcome to the Forum!

This macro will do what you asked for.

Please Login or Register  to view this content.

Hello Mark,

I don't have an answer to that. I have varied data on the worksheet and can not reproduce the error.

Hello Mark,

Can you post the workbook?

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Hello Mark,

Thanks for posting the workbook.Found the problem. The macro was expecting row 1 to have the headers. You started the headers in row 2. I changed the macro. Here is the update code. It ran correctly on the posted workbook.

Please Login or Register  to view this content.

Hello Mark,

You're welcome. Thanks for marking the post "Solved". I will remember the cause of this problem for the future.