Referencing Workbook Tabs

  • Thread starter Thread starter avonfromclbates
  • Start date Start date
A

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
 
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)
 
Back
Top