Incrementing Rows in a Macro

[JamesFletcher]

Hi all,

I have written a very simple macro for the attached worksheet to add a new row and copy the formatting from the row below and then clear it ready for data entry.

As you can see, there will be options for new Plans, Pros and Data but I can't write the macro in the same way as it is using specific rows and any new Notices force the rest of the worksheet down by one.

Is there a way to tell these macros to look for the correct row and then insert, copy and clear?

Thanks a lot.

[stanleydgromjr]

JamesFletcher,

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).


In the New_Notice macro:

Please Login or Register  to view this content.

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then test the New_Notice macro by clicking on the New Notice button.

[JamesFletcher]

Thank you but the New Notice macro isn't the problem. If I wrote a macro for new Plan, Pro, or Data, I can't tell it a specific row as it may not be e.g. row 41 I want to insert the new row.

[stanleydgromjr]

JamesFletcher,

In the Quick Reply box, just put the word BUMP. Then, click on the Post Quick Reply button, and someone else will assist you.

[JamesFletcher]

Thanks Stanley, it took a few helping hands but I figured it out in the end.
FYI here is the code I used:

Please Login or Register  to view this content.

[stanleydgromjr]

JamesFletcher,

I am glad that you were able to come up with a solution.