Macro to copy a range of cells to another worksheet

Sorry about the double post, can it be deleted?

Hi,

I am trying to copy a range of cells from one worksheet to another using a macro.

I have an input box which asks for the start cell and another input box that asks for the end cell.

How do I then copy from 'worksheet1' the selected range of cells into 'worksheet2'

jonnyuk3

Cross posted at ozgrid.

http://www.ozgrid.com/forum/showthre...d=1#post449745

Thanks Reafidy.

jonnyuk3,

Please read forum rules below before posting as cross posting without the link is not permitted

link may help or do a search as it be answered many times before

http://www.rondebruin.nl/copy1.htm

VBA Noob