If you want to retain the destination row / column size, select Paste
Special | Values from the Edit menu.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"danlinksman" wrote in message
...
Is there a way to copy rows and colums down and keep the row height and
width
the same?