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.



cappy2112 wrote:

I understood your reply, however, that applies to the version number
function I want to call from the Spreadsheet.

Are you also suggesting that I put the existing code (the code that
was in place before I started maintaining this project)
in a new module as well?

On Jun 18, 12:51 pm, "Chip Pearson" wrote:
Do NOT put the code in the code module associated with a worksheet. Re-read
my replies. You need to CREATE A NEW MODULE.


--

Dave Peterson