Function which declares all ranges

[katya_p]

Hello everyone!

I want to create a function initialize() where I can declare all my ranges from the workbook. So I can use them in every sub.

Smth like this:

Please Login or Register  to view this content.

But it turned out that I can not just execute this function at the beginning of each sub or at the very beginning of the file..I need "=".

How to do it correct?

Thnak you!

[TMS]

Maybe something like:

Please Login or Register  to view this content.

Regards, TMS

[katya_p]

Thank you!

[TMS]

You're welcome. Thanks for the rep.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save