Hi, i am trying to have vba copy a sheet, and paste it over a sheet in excel here is the code i am using
Sheets(TabName).Copy After:=Workbooks(ControlFile).Sheets(1)
how do i get it to copy a sheet, then paste it without renameing it to say
testing(2) when testing already exists, i just want it to paste it
thanks
Bookmarks