Ivan Raiminius Wrote:
Hi,

you need to rearange your code to get rid of "ActiveCell.Offset(1,
0).Select" in the inner loop.

Regards,
Ivan

If I remove that code my function ceases to be of any use...

Why is the offset causing the X1 to increment?

Any suggestions of a better way to do it?


--
darkman
------------------------------------------------------------------------
darkman's Profile: http://www.excelforum.com/member.php...o&userid=34689
View this thread: http://www.excelforum.com/showthread...hreadid=544554