Hey, I have about 20 different sheets from which I need to select 5 row
out of the middle, about 15 columns long and put it into a ne
sheet...Anybody have any idea how to get this into VBA so I dont hav
to copy and paste it all, I also want to make sure that when I go t
paste it into the new sheet, it makes sure that it comes to an empt
box before it pastes, so that I dont lose any data.
Any help appreciated. - Be

--
bm446
-----------------------------------------------------------------------
bm4466's Profile: http://www.excelforum.com/member.php...fo&userid=3394
View this thread: http://www.excelforum.com/showthread.php?threadid=53724