Apologies for my mistake I meant to post this to the
Excel.WorksheetFunctions newsgroup.......
Is there a way of displaying the tab name in a cell?
PWS
"Nigel" wrote in message
...
Maybe.....
Range("A1") = ActiveSheet.Name
--
Regards,
Nigel
"Paul W Smith" wrote in message
...
Is there a way of displaying the tab name in a cell?
PWS