Worksheet naming
I had create a macro that create a copy of the
active sheets on another workbook.It works OK.
But I having problem with renaming the copied
sheet.
I have below simple code for renaming the copied
sheet :
With activesheet.
.Name = .Range ("A12").Value
.Save
End With
But if the sheet with that name already exist,it will
produce an error.How to trap that.I want the old
sheet whit that name is replaced with the new one.
Thank's in advance
Rgds,
Shiro
|