View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Diarmuid Diarmuid is offline
external usenet poster
 
Posts: 7
Default Using VBA functions in MS Excel

Thanks very much for the help!

Boy do I feel sheepish :{


Its amazing how simple the solution is when somebody points it out to you!
--
Just getting used to VBA!!!



"Niek Otten" wrote:

<I've created a function in a worksheet

If you mean in a Worksheet Module, then that's the problem.
The function should be in a standard module (from InsertModule)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Diarmuid" wrote in message
...
Hi,

I've just strarted using vba function to automate some of my spreadsheets.
I've created a function in a worksheet, but no matter what I try I can't
seem
to access the function from a cell - any help would be greatfully accepted
--
Just getting used to VBA!!!