compiler error in calling Exell functions

[Mehrdad hakimzadeh]

When I want to use ROW(), COLUMN()and ADDRESS() functions
in an Exell macro, I receive the message "Compiler error:
Sub or function not defined.".

Thanks

 

[Frank Kabel]

Hi
if you're using the worksheetfunction object these worksheet functions
are not supported in VBA. Reason: There're VBA equivalents.

e.g.
with activecell
msgbox .row
msgbox .column
msgbox .address
end with