worksheetname

[excel-tr]

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

 

[Norman Jones]

Hi Sahrayicedit,

See xlDynamic at:

File Path, File and Worksheet Names
http://www.xldynamic.com/source/xld.xlFAQ0002.html

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)