compiler error in calling Exell functions

M

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
 
F

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
 
Top