Selecting of Sheets in VBA

[Shahid Pasha]

Hello All,

I need a code which helps me to move my sheets to new workbook. But this sheets name will be renamed every week. So kindly suggets me how can I define the variable for this.

Thanks in advance.

 

[Deepak]

Hi,

Welcome to the board!

If same sheets are getting renamed then you can use the sheet code name



Here! instead of referring sheets("abc") use sheet1