I think that I have had the same problem using INDIRECT as you, where
the data inside the quotes (!C5 in your example) is not modified when
inserting rows or copying and pasting. I solved this by filling column
A with the ROW() function. You then need to replace "!C5" with "!C"&A5.
If the formla is then copied to row 6 for example, the reference
becomes "!C"&A6 whereas "!C5" would remain "!C5".

Hope this helps.

Rob


--
WightRob
------------------------------------------------------------------------
WightRob's Profile: http://www.excelforum.com/member.php...o&userid=13799
View this thread: http://www.excelforum.com/showthread...hreadid=477948