right now i'm building the formula on a worksheet open event. i can do it in vb,
just can't figure it out with a cell formula

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...

i'll simplify a little here. i have a separate workbook with rates and some
named ranges. let's say one is Joe_Tier1 and another is Bob_Tier1.

then bob and joe have separate workbooks.

if i have their name in A1. how would i write a formula to replace "Joe" wit
the value in A1?

Rates.xls!Joe_Tier1*G58




--


Gary