Referring to workbooks with variables

Hello.

I have two workbooks called RTB and NSG. I want to create a macro that transfers data from RTB (sheet 34 specifically) to NSG (sheet 4), but sometimes the person who manages RTB adds a column. If I set up a macro to transfer the data from column F, for example, if the admin adds a column before, then that column will be column G and my macro will transfer the wrong data.

I want to add a validation process at the beginning of the Macro to verify the columns and names have not changed. I am trying to refer to the workbooks as variables, however, I am having a problem with referring to separate workbooks. for example, the following code is giving me a Runtime error 9 'subscript out of range' on the last line.

Please Login or Register  to view this content.

Any idea what is causing this? thank you in advanced.

PS: the macro is being stored in the NSG workbook. Thanks

so I guess it is a syntax error. the line works if I change

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

but I remember using the other syntax. Am I getting it confused with another programming language?