How do I Insert a row that includes copied formulas

  • Thread starter Thread starter A Maurer
  • Start date Start date
A

A Maurer

I may be in way over my head here (I have never written or used any
macros before) but I am trying to write a macro that will do the
following:

1. Find the next blank row after row 4 in column B.
2. Insert a new row at that point, shifting the entire row(s) below
the new row down.
3. Copy the formulas contained in J2:Q2 into this new row.

I have been searching through this group and other web sites for the
programming to do this but have not found anything close enough to
what I need, that I am then am to alter the exact cell/column numbers
to fit. I would greatly appreciate any and all help. Thanks

Andy
 
You must log in or register to reply here.

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

Keeping formulas on an insert 1
Insert Row also adds formulas and moves cursor 2
Excel Help to copy information from one row at a time to another sheet 1
Insert Value into cell automatically when new rows are created/inserted 1
Macro: insert rows anywhere in the sheet 4
Changes in How Code Acts After Upgrade of Excel 2
Eliminate blanks while copy row and transpose 11
Insert row and fill down formulae 2

Back
Top