View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] zigzagdna@yahoo.com is offline
external usenet poster
 
Posts: 16
Default How to assign a worksheet in VBA

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,