View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carole O Carole O is offline
external usenet poster
 
Posts: 69
Default Named range changes values

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