change your formula notation for A1 to $A$1

See help file
Switch between relative, absolute, and mixed references


Reference (Description) Changes to
$A$1 (absolute (absolute cell reference: In a formula, the exact
address of a cell, regardless of the position of the cell that contains
the formula. An absolute cell reference takes the form $A$1.) column and
absolute row) $A$1
A$1 (relative (relative reference: In a formula, the address of a cell
based on the relative position of the cell that contains the formula and
the cell referred to. If you copy the formula, the reference
automatically adjusts. A relative reference takes the form A1.) column
and absolute row) C$1
$A1 (absolute column and relative row) $A3
A1 (relative column and relative row) C3


--
mudraker

If my reply has assisted or failed to assist you I welcome your
Feedback.

www.thecodecage.com
------------------------------------------------------------------------
mudraker's Profile: http://www.thecodecage.com/forumz/member.php?userid=18
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68908