I am facing problem while defining worksheet.

[ThrottleWorks]

Hi,


I am facing following problem while trying to define a worksheet.

I am getting Run - Time error 438

Object doesn’t support this property or method


I am trying to define sheet named as working, I am using following code.

Dim wrk as worksheet

Set wrk = worksheets(“Working”)


Can anyone help me in understanding this error.


After defining the code, I am replacing worksheets(“Working”) with wrk but not able to do so.

 

[Brant]

Where is the error happening? At the 'Set wrk = worksheets("Working")' line or later?

 

[ThrottleWorks]

Hi Brant, the error is occuring later when the line try to run wrk

 

[Brant]

Can you post the line that is givin you the error?

 

[ThrottleWorks]

Hi Brant Sir, thank a lot for the reply.


Here is the line


macro.wrk.range ("a1").value = from_date


Please note - macro is defined workbook & code related to macro is running fine.

 

[Brant]

Sure thing..


If you remove "macro." from the beginning of the line, your code should run. When you set 'wrk = worksheets("Working")', Excel knows the workbook that the worksheet is in. So, by adding your definied workbook variable to the beginning of 'wrk.range("A1")', you are essentially telling Excel 'Workbook.Workbook.Worksheet.Range("A1").'


Let me know if that works for you!

 

[ThrottleWorks]

Hi Brant Sir, this has worked ! thanks a lot for the reply, have a nice day ahead.

 

[Brant]

You're welcome. Same to you!