Carole O,
Have you tried Row and Column reference in your VBA program?
$A$1 is R1C1
$K$5000 is R5000C11
VBA might work better with this reference.
HTH
:-)

"Carole O" wrote:

Excel 2003 SR2

I'm working through some VBA and save often to other worksheets. I have
several named ranges (Rows1_5000, 5001-10000, etc). The range is from $A$1
to $K$5000. But I notice that ranges sometimes change to H or C in place of
K. I have the $ in front of the row and column - I thought that would keep
it defined as I wanted. How come it changes? What can I do to keep it the
way I first defined it? It is very time consuming to continously check and
change it.

TIA,

CaroleO