VBA Range Issue

[Fredek]

Hi guys,

  Worksheets("Extract").Range("GCMR_Data_Table[CRMSID]").Select

The above code is giving me "Select method of Range class failed". Would you guys be able to tell me where I'm going wrong?

I'm trying to select the data in column CRMSID from the GCMR_Data_Table in sheet called Extract.

Thank you!

 

[Tetra201]

Is Worksheets("Extract") the active sheet?

 

[Fredek]

Hi Tetra, no the sheet is not active

 

[Tetra201]

You cannot select on a non-active sheet. Try

Worksheets("Extract").Activate
Worksheets("Extract").Range("GCMR_Data_Table[CRMSID]").Select