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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Mehrdad hakimzadeh" schrieb im Newsbeitrag
...
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