View Single Post
  #8   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Mon, 17 Jan 2005 09:43:17 -0600, "Chip Pearson" wrote:

If you insert a row somewhere in 1:9, the reference will change
and the formula will return an incorrect result. It is thus
preferable to use the INDIRECT function.


Ahh. Thank you for that information.


--ron