Making Sum ranges Absolute

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

Guest

I've written a macro that inserts numbers in a column that I want to sum.
When I try to use the sum formula, the cell references change each time a new
number is inserted.

I want to keep the cell ranges constant and not change. The numbers inserted
will never exceed the cell ranges defined.

Thanks,
Ken
 
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

Absolute References and Inserting columns 1
Sum Formula with variable range 2
Help Writing a SUM Formula 5
Error when using Sum command 3
Summing rows using formulas with variables 1
Sum a dynamically-defined range 3
Insert a Row and then Sum 1
Numbers showing Up Centered in Cell ? 1

Back
Top