View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
cappy2112 cappy2112 is offline
external usenet poster
 
Posts: 13
Default First Time VBA user- really easy question :-)

On Jun 18, 1:40 pm, Dave Peterson wrote:
The code for the UDF belongs in a General module if you want to call it from a
formula in a cell.

If you have that same code behind a worksheet or behind ThisWorkbook, it
probably can be deleted with no problems--but you'll want to test.

As for the rest of the code, I didn't see anything that would indicate that it
belongs in one spot or another. So it would be difficult to guess.


I'd rather have all of the code in the same module, and delete the
code from the worksheet.
I'm pretty sure it can be deleted and moved. It's only a few
functions.