Thanks for your reply David,

The reference "Data!29" is a typo, it should read "Data!J29" as in the
example below. I have only one question.

What I am trying to do is automatically paste a range of values from
one worksheet to a specified location on another worksheet (named Data!
in my example).

The address of the start cell on the worksheet Data! is J29. This
address already appears on the first worksheet (it's value changes
relative to the week number).

If I was doing this manually, I would simply copy the data on the first
sheet, go to the cell J29 on the sheet Data! and paste the data in.

I want to automate this with a macro. What I don't know how to do is
make the cursor move to cell Data!J29 from within the macro.

Hope that clarifies it.

Regards

Rob


--
WightRob
------------------------------------------------------------------------
WightRob's Profile: http://www.excelforum.com/member.php...o&userid=13799
View this thread: http://www.excelforum.com/showthread...hreadid=476658