I'm working on a paste special macro so as to help aliviate some of the
difficulties accociated with using my parts list.

If will work in the following manner

Paste the values to a static location (say forinstand, A200)
Count the size of the selection
Cut & Paste A200 to location
cut & paste A201 to location + 1
cut & paste A202 to location + 2
etc.

Here is the trick... when I get to row 40 or so, I have to skip about 4
rows then resume. How do I do that?


--
wilro85
------------------------------------------------------------------------
wilro85's Profile: http://www.excelforum.com/member.php...o&userid=26935
View this thread: http://www.excelforum.com/showthread...hreadid=494956