Thread
:
My first macro - doesnt work - function not recognised
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
Posts: n/a
My first macro - doesnt work - function not recognised
Please decide where you want to post
--
Don Guillett
SalesAid Software
"James Cornthwaite" wrote in message
...
I have written my own function FindNominal (as below) in a macro in excel.
I
want to use this function repeatedly in my excel spreadsheet.
Function FindNominal(NomCode)
FindNominal = Vlookup(NomCode, IMPORTDOC, 5 false)
End Function
but it does NOT work.
It reports
Vlookup is not recognised.
Do i need to write an import statement?
IMPORTDOC is defined as a range of cells in excel by the name, define
command.
I take it this is acceptable?
Thanks
Reply With Quote