View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Excel Data Ranges Columns

hi
what version xl are you using?
2003 here.
are we talking about named ranges?
if so, adding a column (or row) next to a named range doesn't automaticly
extend the the named range. only when the column (or row) is added within the
named range will the named range be extended. if added outside the named
range, i think you will just have to rename/redefine.

post back if i misunderstood.
Regards
FSt1

"Richard" wrote:

Hi
Has anyone seen a problem whereby the addition of a new column heading
beside an existing data range does not cause the range to be extended to
include this column. The selection to "extend rows and columns" is turned
on. Is there some similar option dealing with data ranges, different from
excel ranges?

Thanks in Advance
--
Richard from Dublin