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???
|