How to assign a worksheet in VBA

[zigzagdna]

Subject: How to assign a worksheet in VBA
I have declared following:
Dim wsDec As Worksheet

Now I am doing this
Set wsDec = ActiveWorkbook.wsDecoupling

Where wsDecoubling is a worksheet in my workbook, but I get an error
Object does not support this property or method, what is the correct way to refer to a sheet in a wokbook in VBA.

Thanks,

 

[Ben McClave]

Try

Set wsDec = ActiveWorkbook.Sheets("wsDecoupling")

 

[zigzagdna]

Subject: How to assign a worksheet in VBA I have declared following: Dim wsDec As Worksheet Now I am doing this Set wsDec = ActiveWorkbook.wsDecoupling Where wsDecoubling is a worksheet in my workbook, but I get an error Object does not support this property or method, what is the correct way torefer to a sheet in a wokbook in VBA. Thanks,

Ben:
Thanks a lot for answering my naive quetsions. Really appreciate your help.

 

[Ben McClave]

Happy to help.