Dim/Set sheet

[mahmed1]

Hi all,

i am having a problem where i have multiple macros (subs) and i am declaring the same sheet and setting it multiple times
i.e dim ws as worksheet and set ws = sheets("sheet1")
now i make the dim global by putting it right at the top

is there a way i can do that with set part so i dont have to keep setting it to the same sheet over and over again?

 

[Andrew Poulsom]

Sorry, no. A constant can't be an object.