Please Help .... Level= Very Easy

[ryancey]

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.

 

[RickXL]

Hi,

I think you might be looking for: Worksheets("Customer_Selection")

Then it depends on what you want to do next. Examples might be:

Worksheets("Customer_Selection").Range("A1").Value = 99

Worksheets("Customer_Selection").Range("B2").Select

 

[ryancey]

Thanks Rick.

The issue is that "customer_selection" is not really the name of my worksheet.

"customer_selection" is the name of a range that represents the new tab name.

In my case "customer_selection"="Ahold - Tops".

So I had previously used:

ActiveSheet.Name = Range("Customer_Selection").Value

to name the worksheet.

I move from that tab to copy data from somewhere else, and I need to move back to it by using "range" somehow.

But this is where I get confused.

Thanks Rick.

 

[RickXL]

Sorry, you are quite right.

If your worksheet's name is "Ahold - Tops" then use that:

Worksheets("Ahold - Tops").Range("A1").Value

Or you could say:

Worksheets(Range("Customer_Selection").Value).Range("A1").Value

Or you could give the worksheet an object name and then use that as a handle for that worksheet from then on:

    Dim ws As Worksheet
    
    Set ws = ActiveSheet
    
    ws.Name = ws.Range("Customer_Selection").Value
    
    ws.Range("A1").Value = 99