View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Functions in VBA used in spreadsheet cell

Original was a couple days past so prolly a slim chance.



On Sat, 19 Apr 2008 12:02:38 -0500, Dave Peterson
wrote:

Thanks for reading the response better than I did!

Maybe JRXPL (gesundheit!) will see your message.

Gord Dibben wrote:

Sheets do not have "general modules".

Workbooks have them.

Sheets have "sheet modules" which Dave instructed you to stay away from.

Make sure your function is in a General module--not under the ThisWorkbook
module, not behind a worksheet module.


Remove the function code from the sheet module and place it into a general or
standard module.

Gord Dibben MS Excel MVP

On Fri, 18 Apr 2008 06:43:06 -0700, JRXPL
wrote:

Thanks for checking it. It is in the general module for the sheet the cell
is in. I even tried typing it in a cell in all sheets. Still not working???