There are four variations of absolute/relative cell addresses:

A1 = row & column are both relative
$A1 = column is absolute; row is relative
A$1 = row is absolute; column is relative
$A$1 = row & column are both absolute

=$b1+$b2 will always point to column B, but the row refernce is relative,
so it changes as you copy it up/down. Put a $ in front of the row numbers to
make them absolute:

=b$1+b$2 or =$b$1+$b$2

Hope this helps,

Hutch

"sjwillow" wrote:

Hello,

Does anyone know why the "$" command will not work in formulas when running
VISTA? Does anyone have a solution?

A simple version of my problem is:

=$b1+$b2

When you drag down the formula in a column, it will continue to auto fill
with the next number despite the stop function "$" and will look like:

=$b2+$b3
=$b3+$b4
and so on


Any help would be greatly appreciated.

--