What does this refer to?

  • Thread starter Thread starter lukus2005
  • Start date Start date
L

lukus2005

I'm trying to understand the spreadsheet a former worker created and I
can't understand the following...

He created a price list and when I move over any of the prices in his
list, it shows =PlainNMB(N15).

I know what PlainNMB stands for as this price list if for Plain
Aluminum with No Moisture Barrier and the N15 refers to a cell.

What confuses me is that there doesn't appear to be a list named
PlainNMB so where is it pulling the dollar amount from? N15 on that
worksheet refers to a cell that only has the value 1 entered in it.
 
One of the nicer things about excel is that users/developers can write their own
functions (called User Defined Functions).

I'd bet that this is one of those.

You can read about how these are developed (and where they're stored) here:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)
 
Back
Top