I've used a named range to name a new worksheet that I've created.
Now that its the new name, I need to move off the sheet to perform an action.
How do I move back to the worksheet using the newly define worksheet?
I rarely work in VBA and almost always need MrExcel forum users' help anytime I attempt to do so.
ActiveSheet.Name = Range("Customer_Selection").Value <--- this piece works
Worksheet.Range("Customer_Selection").Value.Select <---- I have no idea how to write this part.
Thank you for taking time out of your day to help another human.
Now that its the new name, I need to move off the sheet to perform an action.
How do I move back to the worksheet using the newly define worksheet?
I rarely work in VBA and almost always need MrExcel forum users' help anytime I attempt to do so.
ActiveSheet.Name = Range("Customer_Selection").Value <--- this piece works
Worksheet.Range("Customer_Selection").Value.Select <---- I have no idea how to write this part.
Thank you for taking time out of your day to help another human.