Code Formula

  • Thread starter Thread starter Nikki
  • Start date Start date
N

Nikki

All:
I am in need of code help for inserting a formula down a column of 26 rows.
I typed the formula and copied it down to the last cell but that will not
work for the next time I use the macro since it will be the next column. Any
help is greatly appreciated.

Thanks
Nikki
 
Thanks so much. One other question, if I wanted to copy say five rows down
and then use a sum formula that is directly to the left (copy preceeding cell
to the left), how could I incorporate this into this code. I could use the
same code and modify the formula but was hoping one line would give me what I
would need.

Thanks again.
 
I'm pretty sure this shorter macro will do the same thing your code does...

Sub Copy26Rows()
Selection.Copy Selection.Resize(26)
End Sub
 
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

VBA set thick borders around non empty cells in range 0
Mid column sum formulas with varied ranges to sum 17
Excel VBA 1
Insert Row also adds formulas and moves cursor 2
Copying a formula to a range 2
Keeping formulas on an insert 1
Insert Value into cell automatically when new rows are created/inserted 1
simple code but it doesn't look like usual vba code 2

Back
Top