Selecting Sheets


Redim Preserve arNames(1 to 5) 
Sheets(arNames).Select
Worksheets(2)


Worksheet Name - This is different to the worksheet code module name
SS - emm.com/excel-vba-worksheet


You can use the worksheet code module name in your code which can be useful if you think the user might rename the worksheet.





© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext