so would I just paste this code into a cell where I would open up a VBA
module?

In Excel Alt-F11 to open the VB editor
Select the name of your workbook in the left panel to highlight it
Right-click insert module
Paste the code in the large right pane
After testing close the module window with the smaller x top right
Collapse the tree against your workbook name
Close the VBE

To use the UDF (user defined function) in a cell type =fnNote(A1) to return
the name of the note in cell A1, which should contain a number between
0-127. Alternatively
=fnNote(60)

Did you try the named formula method

Regards,
Peter T


"Omar" wrote in message
oups.com...
thanks...I need to sit down with this and figure it out. thanks for
the running start.

so would I just paste this code into a cell where I would open up a VBA
module?