Can not change cells from VBA

[santashelper]

tried to change cells from VBA with:

worksheets("sheet1").cells(10,"A")

statement does not execute. Just aborts

[JieJenn]

You need to assign a value. Change your codee to Worksheets("Sheet1").cells(10, "A").value = "XYZ"

[santashelper]

sorry I meant

worksheets("sheet1").cells(10,"A")="OK"

[JieJenn]

Works for me.

[santashelper]

The entire code is:

Public Function Test() as String
worksheets("sheet1").cells(10,"A").value="OK"
Test="OK"
End Function

When type =test() into a cell and hit return it puts #Value in that cell and nothing in cell A10.