I have an excel spreadsheet with coding mixed between vba modules and excel functions. The spreadsheet has up to 8 columns that can be used. Several of the rows have named ranges. I found that I could perform a calculation for each column by referring to the named range (energy) in an excel formula. The formula has nested if-then-else statements which I would rather write in a vba module. I would like to use the named range in the vba function. however I cant find a way to reference the named range. Also the spreadsheet is about to get more complicated as I will be adding a new row (as well as new worsksheets with additional tables) that will increase the choices that must be made. I am reluctant to write the excel formula with even more nested if-then-else statements.

MUcalc-for-ee.xls