Run-time error 438 Object doesn't support this property or method

[TheBoss_U2]

Hello everyone,

I have a worksheet to show the progress of activities on field, but each time I select the button I receive the message "Run-time error 438 Object doesn't support this porperty or method". When I run the debugger it locates at "Call ThisWorkbook.CreateStatusOverTime"

Private Sub CommandButton1_Click()
Call ThisWorkbook.CreateStatusOverTime
End Sub

Can somebody help me to find a solution. I think is simple but I'm not an VBA expert.

 

[Debaser]

Do you actually have a routine (Sub or Function) in the ThisWorkbook module that is called CreateStatusOverTime?

 

[TheBoss_U2]

Yes, inside ThisWorkbook, first line is

Sub CreateStatusOverTime()

'Attached file

 

[Marc L]

Hi !

Use step by step debugging mode (via F8 key) to find out
where exactly error occurs …
​

 

[Debaser]

You mis-spelled Range here:

  'FirstTestnameRow = 6
  FirstTestnameRow = Worksheets("Data").Rage("B15")