When I run the above, it shows error- "Invalid Use of property"- Please help me to remove it.

[Neel Kamal]

Sub akele_1()

ThisWorkbook.Sheets ("Sheet1"), Range(a2), Value = "It's going to work now"


End Sub

When I run the above, it shows error- "Invalid Use of property"- Please help me to remove it.

 

[Fluff]

Hi & welcome to MrExcel.
How about

 ThisWorkbook.Sheets("Sheet1").Range("a2").Value = "It's going to work now"