why do I get object doesn't support this property or method?

Question

for some reason

MsgBox (VarType(Application.WorksheetFunction.Address(1, getRowOfTestCode, 4, 1)))

where getRowOfTestCode = 13

throws the

error 438 "object doesn't support this property or method"

What am I missing here?

Answer 1

Address is not available in VBA via WorksheetFunction

You can instead use something like

Cells(rowNum, colNum).Address(False, False) 

It's not clear from that one line what the context is for this though, so some other approach might be more useful.