Copying forumla into another Cell.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have just created a pretty long formula. It is in e4. Now I want to copy
this formula into all of the e5-whatever cells. But when do this it
increases the formula also. How can I copy this formula into the other cells
with out having it increase the cells it's trying to copy from?

Thanks
 
I don't understand what you mean by "increase the cells", however, I would
copy using code like:

Range("E5").Copy Destination:=Range("E6:E20")

If you want to copy the formula without changing the cells referenced in the
original formula, make the cell references absolute:

=$G$5+$H$5
 
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

Tricky Formula 2
Need Macro... 8
Conditional formating not working 5
Macro Help 5
If Condition 4
Macro for checking data in a cell against another cell andcopying/pasting data 8
Better way to apply formula to multiple cells? 4
Insert Value into cell automatically when new rows are created/inserted 1

Back
Top