Problem setting values for a range

Hello,

I am trying to set some values for a range but am a bit stuck.
When using this code it works fine:

Please Login or Register  to view this content.

But when using this code i get a Run Time Error 1004

Please Login or Register  to view this content.

Can any body help me here and point out why this produces an error, i want to use the second option to set values for a variable range and prefer to use the Cells() method?

Thanks!

Could you provide your workbooks? Would be easier that way.
I think this might be caused because you need to clarify what workbook and cells you are refeering to, and the later part of your code is trying to reference the book2 cells.

You could try to add this bit of code at the start of the module:

Please Login or Register  to view this content.

And replace that line of code with:

Please Login or Register  to view this content.

As you can see the difference is that my line is refering to a specific workbooks worksheets cells.

Thank you very much i think you helped me figure it out.

The issue was the way i selected my range, i was using

Please Login or Register  to view this content.

Whereas, the way your wrote it using works just fine

Please Login or Register  to view this content.

I tried it and all working! thanks again.