To include Depot
Hello From Steved
Set wksT = GetWorksheet(wks.Parent, _ "Sheet" & Left(cell.Text, 2)) I've made Changes to the above Set wksT = GetWorksheet(wks.Parent, _ "" & Left(cell.Text, 8)) It now names the sheet "Papakura" instead of SheetPapakura. Please what Do I enter in the above code to add Depot as an example "Papakura Depot". Thankyou. |
All times are GMT +1. The time now is 03:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com