View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_5_] Sheeloo[_5_] is offline
external usenet poster
 
Posts: 248
Default Adding rows to the data array used in an Index function

Excel will update the references if you are using relative references... any
reference with $ in front of row number will not change...

References of type -
A1 will change
A$1 will not change
$A1 will change
$A$1 will not change

References inside INDIRECT won't change...

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Lanhing" wrote:

If I add rows to my data set...

1) Will the array automatically adjust?
2) Will any cells that reference the cells beneath the rows I add
automatically adjust to the new locations? Or will I have to manually go
into every index and update the row number needed??

Thanks!