using excel functions in a macro - my first macro! ?

  • Thread starter Thread starter James Cornthwaite
  • Start date Start date
J

James Cornthwaite

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My first macro - doesnt work - function not recognised 2
using excel functions in a macro - not familiar with macros at all 6
My first macro, uses Vlookup but doesnt update unless hit enter 1
My first macro, uses Vlookup but doesnt update unless hit I enter 3
Macro Query - 6
Color contents of a cell accessed by a function? 4
changing the appearance of a cell accessed 1
Macro Stoped Working 2

Back
Top