>
> Hi Paul, and thank you for your assistance
>
>
Turns out Excel has a 30 character naming limitation for Sheets hence the
reason for the unnamed sheets.
I have updated the code to reflect your suggestions as well as
ActiveSheet.Name = Left(cVal, 30).
Works a treat now.
Thanks again.
Mark.
I'd give this a try:
first of all (irrelevant to the problem)renaming the sheet should work as:
Activesheet.name = cVal
as for the problem itself,I suspect there's another error occurring that is NOT
Error 1004.I'd suggest changing the section to:
On Error Resume Next
