cell ref w/ varaibiles

  • Thread starter Thread starter dave h
  • Start date Start date
D

dave h

Can you make a function ie: Sum(a5:a10),
have the a5 and a10 as individual "cell" variables in
order to change your function very fast by typing numbers
into two "VARIABLE" cell ranges for the functions address
for example:


CELL B1 CELL B2
15 25

Then:

SUM(A&"+b1":A&"+b2")???
Have your cell refs as varaibles to change the formula
very fast?
 
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

Naming non-contigent cells with vba 5
Add to an Existing formula in a Cell using VBA 1
Need macro that concatenates cells with text 7
Adding up range of cells exclude hide cells 7
How to check if a certain function is used 2
Marco 3
Using the INDIRECT function across multiple worksheets 1
Linking cell through variable 1

Back
Top