I hate excel and ive been asked to create a simple macro... easy huh?

I need to be able to copy a range (ie: A1 to F5) from a worksheet to an active cell on a different worksheet.

Can some kind soul tell give me the code for this.

This is a very useful site for excel questions

http://www.mrexcel.com/board2/viewtopic.php?t=158427

http://www.mrexcel.com/board2/search.php?mode=results