Use variables defined in sub in my function

Hi,

When I write a function, do I have to redefine my variables? What If i want to use a variable that I defined in my sub?

For example:

Please Login or Register  to view this content.

How do I use Wa in my function without redefining it?

Hi niko,

not sure what you mean. You don't have to redefine your variable, but you can assign different values to it later on. After you assigned the value "Worksheets(2)" to your variable, you can use it instead of it. Like this:

Please Login or Register  to view this content.

is the same as

Please Login or Register  to view this content.

If your want to change the value, you just make another "Set" statement. For example

Please Login or Register  to view this content.

edit: never mind, I completely misunderstood.