Hi,

I have the following problem in excel:
I want to write code in VBA to clear the contents for rows J13:J224.
The only problem is that, when I insert a row in this range, cell J224
becomes cell J225.
Is it possible in VBA to make an absolute reference to cell J224? It
should be possible to insert multiple rows in the range (J13:J224).
Thanks in advance!


--
leonidas
------------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375
View this thread: http://www.excelforum.com/showthread...hreadid=553151