Referencing Workbook Tabs

[avonfromclbates]

I know that you can return the path of a workbook by enterin
=Cell("filename"), but I want to just reference each tab name of th
workbook on the respective sheets. Is there any quick way of doin
this without doing a right function

 

[Bob Phillips]

Not really.

Also use =Cell(filename,"A1") otherwise all the references will change
together.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)