Run Time Error 1004

[jt01]

Hi Guys,

I was hoping you could help a run time 1004 error I am getting on the following code:

Please Login or Register  to view this content.

The part that causes the error is:

Please Login or Register  to view this content.

I have looked up Microsoft help on the matter and gone through posts on this forum but have had no luck. Is anyone able to shed any light for me?

Thanks heaps.

Cheers

James

[mrice]

If you are using the Workbook().Sheets().Range(Cells( , ),Cells( , )) construct, the Cells must be on the same sheet.

i.e It would be worth trying...

Please Login or Register  to view this content.

[jt01]

Hi Martin,

Thanks for your reply.

That is fantastic - thanks so much. It works perfectly now.

Have a great night

Cheers

James

[jt01]

Hi -all solved - not sure how to close the thread or if thats done by the moderator.

Anyway, thanks heaps!