Copying columns from one workbook to another

Hello.
I know this could be very simple but anyway... it does not for me!

I have a template. I click the button which should open a workbook (with measurement data). I want to copy column C from this opened file to template, first free column (starting with B).

sheets("data").range("C:C").copy destination:=workbooks("template").sheets("data_T").range("B:B")

I have also tried to record a macro while doing this copy. I used exactly the same code but it does not work.

example:
columns("C:C").select
this also does not work on opened file


What could be the problem? Can anyone please help me?

Thank you.
Peter.

Hello Peterl,

You code is fine which leads to believe that one or more of the Worksheets or Workbooks maybe protected. It would help when post about a problem to also include any error messages you have received.

Sincerely,
Leith Ross

Hi, I get the following error:

"Run-time error '1004':

Method Select of class Range not ... (literally translated from my language)

Regards
Peter.