I just want it to behave like it does in excel, just double click on the
bottom right corner of the selected box and autofill down to the last
data value on the left.

But when i record the macro and look at it it always gives a range.
What should i code to do what i want?

Thanks for all your knowledge,

Chris


--
cbh35711
------------------------------------------------------------------------
cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276
View this thread: http://www.excelforum.com/showthread...hreadid=527852