Hi,

This site should help

http://www.rondebruin.nl/copy3.htm#Range

Think this link will work but have a look at all the options

VBA Noob