C
CuriousMark
How do I return the row number of the current (not necessarily active) cell
for use in a custom formula? =Row() in a cell returns that cell's row number,
but I can't figure out how to use that in a custom formula. For example, code
such as this doesn't work because Excel gives me a compile error on "=Row()".
Public Function myFunction()
Dim Variable As Integer, Result As Integer
Variable = Row()
Result = Variable + 10
myFunction = Result
End Function
Thanks very much.
for use in a custom formula? =Row() in a cell returns that cell's row number,
but I can't figure out how to use that in a custom formula. For example, code
such as this doesn't work because Excel gives me a compile error on "=Row()".
Public Function myFunction()
Dim Variable As Integer, Result As Integer
Variable = Row()
Result = Variable + 10
myFunction = Result
End Function
Thanks very much.