Thread
:
referencing named formula using INDIRECT function
View Single Post
#
5
Rob Hick
Posts: n/a
that not quite what i was after Vasant - i need to reference the name
rather than 'A1'. So on my workbook (XL2000):
=London!MonthSales
is ok but
=INDIRECT("London!MonthSales")
or any permuation of getting the correct text, does not work
Rob
Reply With Quote