many times you could save repeating formulas if you could change the row you
want to reference by pointing to a value in another cell to deisnate the row
you wish to refernce in a formula.

example if your formula cotained the A(B2) and B2 contained a value of 5 the
formula would be refernce A5. If you then change the value of B2 to say 10
the formula would now refence A10.

"Mike@Delphi" wrote in message
...
many times you could save repeating formulas if you could change the row
you
want to reference by pointing to a value in another cell to deisnate the
row
you wish to refernce in a formula.

example if your formula cotained the A(B2) and B2 contained a value of 5
the
formula would be refernce A5. If you then change the value of B2 to say 10
the formula would now refence A10.

Excel's INDIRECT function comes close
http://www.cpearson.com/excel/indirect.htm

/Fredrik

Have a look in Help for the function INDIRECT
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mike@Delphi" wrote in message
...
many times you could save repeating formulas if you could change the row
you
want to reference by pointing to a value in another cell to deisnate the
row
you wish to refernce in a formula.

example if your formula cotained the A(B2) and B2 contained a value of 5
the
formula would be refernce A5. If you then change the value of B2 to say 10
the formula would now refence A10.