I was given this below in BOLD to use for solving a problem now I have no idea how to use it or apply it.
Build your own function. (record a macro, click any cell, stop macro)
Goto the VB Evironment, (in the project window, in the MODULE1)
overwrite the macro1 with the code below:
Code:
Public Function CalcRate(ByVal pvMin) Select Case pvMin Case <38 CalcRate = 13 Case >54 CalcRate = 32 case else CalcRate = 23End Selectend Function
Bookmarks