Ok, so I just want to copy the name from a worksheet into the cell A1, I need this to work relative across 20 worksheets. Also in the same macro is it possible to delete the last 4 characters in the worksheet name?
The worksheet was originally named from the file name and so has .xls at the end of the name.
Any help gratefully appreciated.
Patrick
Bookmarks