How to declare specific range on worksheet on workbook

[Rob K]

Hi there,

I have written this script to update a spreadsheet from another spreadsheet, but I think the code is a little messy and could be tidied up if I was able to use the variables the way I indended.

Please Login or Register  to view this content.

Basically, I would ideally like to use the variable of rSource and rDestination to refer to the specific ranges on a specific sheet on another workbook. Is there a better way to do this please.

Kind regards

Rob

[Miroslav R.]

Hi there,
You can shorten f.e.:

Please Login or Register  to view this content.

can be done like:

Please Login or Register  to view this content.

[Norie]

This uses rSource, rDestination and a new variable, wbDest, for the destination workbook.

Please Login or Register  to view this content.

[Rob K]

Hi Miroslav R., I tried that but get the error message "Object doesn't support this property or method"

[Rob K]

So what does it mean then, "Object doesn't support this property or method"?

[Miroslav R.]

Which line of shortened code?

[Miroslav R.]

Replace 'Windows' with 'Workbooks' and it should be ok...
Sorry but I did not get it before...

[Norie]

Rob K

Was there a problem with the code I posted?

[Miroslav R.]

No was not...
The problem was in my shortened code... I was refferencing to sheeet/range in window and tha was the error. Sheet/range only exist in workbook.
Did You replace that?
Is it OK now?