PDA

View Full Version : worksheetname


aoc
04-10-2007, 01:56 PM
hi,


when I change the worksheetname, I want to a cell; D2; have the same name.I want to use that code for any workbook .

regards
ndendrinos
04-10-2007, 02:20 PM
http://www.vbaexpress.com/kb/getarticle.php?kb_id=213

Hello aoc ; Follow this link . Maybe it will help you
mdmackillop
04-10-2007, 02:20 PM
Have a look at this KB Item (http://www.vbaexpress.com/kb/getarticle.php?kb_id=213)
mdmackillop
04-10-2007, 02:28 PM
I got beaten to the KB reference so here's a formula solution
=REPLACE(CELL("filename"),1,SEARCH("]",CELL("filename")),"")
lucas
04-10-2007, 06:33 PM
That was close. Both posts 2 & 3 at 4:20
ndendrinos
04-10-2007, 06:52 PM
True, BUT if you consider the degree of expertise (rookie vs. master) I should be given top honors.
lucas
04-10-2007, 08:15 PM
Nothing like practicing against the best.