"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