Macro for inserting multiple rows with Formulae and formating

Hello

I am Sreeraj and I am in need of help.

I am developing an excel sheet for my colleagues.

This sheet will be a dynamic sheet and my colleagues will need to keep on adding data to this file. This data may not use more than 700 rows.

I need a macro that
will identify the first blank cell in Column A
As for the number of rows to be inserted and
Copy the formulas and formating of the Row above the first blank cell and paste it in the number of rows defined.

I have a macro (thanks to google) that will identify the first blank cell in Column A and then copy the Row above the first blank cell and paste it once (both the formating and formulae).

It is given below

Please Login or Register  to view this content.

I hope some one can help me with this.

Regards

Sreeraj

Please Login or Register  to view this content.

attach please a sample file

Originally Posted by sreerajmp

This code doesn't seem to work. Can you please advice how to use it.

on your file my macro works, did you assign to Button ?

How did you solve ? please, tell us !