debugging VBA code: compile error: member or member data not found

[Juztkolmever]

Please help what's wrong with this code:

results in compile error: member or member data not found

Sub test()
Dim rng1 As Range


Worksheets.Sheet1.Range("D15").Value = "test"
Stop
End Sub

Thanks

 

[dmt32]

Hi,
welcome to forum

If the tab name is Sheet1 then the line in your code should be

Worksheets("Sheet1").Range("D15").Value = "test"

Dave