Need simple way to insert new row

I have a spreadsheet of safety incidents by date. I would like a simple way to insert a new row at top with all formatting for these fields intact. I know I could simply enter the new row at the bottom, but I would like the newest events at top. Is there a simple way? By simple I mean without VB.


Attachment 432593

Hi,
Just insert (ctl + ) and use the format painter brush.

Thanks for the reply. As you state I can do this easily withe ctrl+Shift + to insert a new row. Then a dialog allows me to select format painter of the line above or the line below. That works perfectly. Now I want to record this in a macro. When I do the exact same selections and record it the results are not even close. Something really wrong happens with I select paint line below formats. Is there a selection on the ribbon to copy the format of the line below?

Hello
Select the row, here I suppose it's Row 2 and try the following code:

Please Login or Register  to view this content.

DBY

Originally Posted by DBY

Hello
Select the row, here I suppose it's Row 2 and try the following code:

Please Login or Register  to view this content.

DBY

OK. So now I am in to visual basic which I have ZERO experience. That said, I have always wanted to learn this. Would you mind spoon-feeding step by step on how I would enter the code? Do I go to the macro i recorded and edit it?

Thank you for the step by step Pepe. I was able to install the code and it did work, but it did not do what I wanted it to do. The steps I want to perform in a macro would be:

1. Select row 3
2. Insert Row
3. Copy formats from row below

expanded.jpg

The VBA code provided did not do this. Can you help?

Dear SJMaye!
Here's a sample. I hope it will be good. Press Ctrl-b and ready.

Have a nice day!

<---------If you like someone's answer, click the star to give them a reputation point for that answer.

Originally Posted by SJMaye

The VBA code provided did not do this.

What did the code actually do?

See if this works.

Please Login or Register  to view this content.

Originally Posted by Pan314

Dear SJMaye!
Here's a sample. I hope it will be good. Press Ctrl-b and ready.

Have a nice day!

<---------If you like someone's answer, click the star to give them a reputation point for that answer.

Hello

That works perfectly on your sample. I got unusual results when I added the code to my file and tried the macro. Weird thing is after I deleted several extra columns to the right the code worked perfectly. There must be something wrong with those columns causing this behavior. I will troubleshoot.

Originally Posted by SJMaye

There must be something wrong with those columns causing this behavior. I will troubleshoot.

Merged cells?

Dear SJMaye!

It has to work! I do not understand what happened. Send in your own file.I type in the code and sends it back.
Maybe I figure out the cause of the odd behavior

Bye!

Hi All,

Sorry for the late reply. I was driving back from TN to WI yesterday (Thanksgiving). I would like to include a copy of the file like Pan requested, but it would do no good. I deleted the columns that were causing the problem. The code works now. I will rebuild the columns. I feel confident these columns had some sort of merging going on, although I cannot be sure. This was someone else's file I have been working with.

I will continue to work on it. If during the column rebuild the issue comes back I will come back to you. Thank you all for your help.

I have found a tutorial which can interest you: adding rows automatically