I don't think you can get the variable from the VBA to the excel sheet
for formula use...

you either have to chnage the VBA, or you could do it in excel without
the VBA


one thing you could do is, to assign the names from the VBA to a list
on the worksheet(let's say it's P1) and then do Vlookup to match up
the name and values...


I'm not sure what's the situation is like, nor you're familiarity with
excel