View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matt7102 Matt7102 is offline
external usenet poster
 
Posts: 1
Default Named Range changes when data is imported

I'm using Vlookup; referencing a sheet that I clear contents (old data),
import new data on. The named range is defined as DATA06;
'0422j!'$A$1:$D$144. After import, I delete column A. The range definition
is changed to '0422j!'$A$1:$C$144. I tried directly inserting the range into
the Vlookup formula, but it changes as well. Any ideas how I can stabilize
the defined range?

Thanks, Matt7102