I have User Defined Function - getRefi(Row()).
I want to assign this function as value to some sepecific cells in worksheet.
I wrote a function as given below, but excel is not recognises the Row() funciton, while it works fine in workbook.
Public Function displayExpectedValues()
startRowValue = InputBox("Enter FirstRow Number to read data")
EndRowValue = InputBox("Enter Last Row Number to read Data")
For Each c In Sheets("Reasult Reader").Range("Q" & startRowValue &":Q" & EndRowValue )
c.Offset(0, 1) = getIZV(Application.WorksheetFunction.Row()) ' excel is not recognizing row() function
c.Offset(0, 2) = getIZV(Row()) ' excel is not recognizing row() function
startRowValue = startRowValue + 1
if startRowValue = EndRowValue Then
Exit for
End If
Next c
End Function
Bookmarks