Creating Dynamic Worksheet Object Variables

[Ark68]

Dim ws_crp as worksheet
Dim ws_cwp as worksheet

x = "CRP"
    Set ws_{x} = activeworkbook.worksheets(x)

Is it possible to build a variable name? I'm not quite sure of the VBA syntax to do so.

I want to build dynamic worksheet object variables based on the value of x. So if the value of x = "CRP", the object variable ws_crp would be created referring to worksheet("CRP"). If x = "CWP", the object variable ws_cwp would be created and set to refer to worksheet("CWP").

 

[GWteB]

VBA does not provide the option to declare variables at run-time. There are ways to simulate this, but which way is the most suitable depends on both the situation and what you intend to do with it. I'm thinking of using an Array or a Dictionary. That being said, I don't see the need for dynamic run-time variable names, especially when using object variables. A well-considered naming of your worksheets, for example, often offers broader possibilities, comparable to the dynamics you are looking for.

 

[Ark68]

Thank you. I will revisit my logic and see what kind of damage I can inflict lol.

 

[GWteB]

You are welcome and hopefully the damage will be limited ?