I think i am getting warmer with that one -
Range("C12").End(xlToRight).Offset(0, 1).Select
It sent the data to the sheet no problem, but it sent it to column B
where the totals and formating finishes.
I ran the macro again to see if it would then paste next to the colum
BD, but it only pasted into the same column again.
thanks anyway so far, some more help and i think we'll crack it!
legep

--
legep
-----------------------------------------------------------------------
legepe's Profile: http://www.excelforum.com/member.php...fo&userid=1548
View this thread: http://www.excelforum.com/showthread.php?threadid=27101