Insert a row

O

ordnance1

I have a worksheet which is 25 columns wide and I need the abilitiy to
occasionally insert a row.

When I insert the row I need all formatting brought down and the formulas in
column A, Y and Z copied down.
 
T

TC Daniel

copy the last working row Cols A-AZ in one swoop and paste this in your new
row.
Formulae/formatting will go with the paste.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting a row 3
Keeping formulas on an insert 1
Insert Row also adds formulas and moves cursor 2
Changes in How Code Acts After Upgrade of Excel 2
Insert Formulas and Formats 2
Run-time error when copying entire row! 5
Macro to insert formulas on last row of different worksheets 1
Macro to insert formulas in the last row of different worksheets 1

Top