Make Variable equal to active range in sheet

I would like to run a calculation based on selected active range in sheet. I tried several methods and cannot make it work. This is what I have so far,

Please Login or Register  to view this content.

Thanks for any help.

Hi,

If you deefine mySelection as a range you need to use the set command (because it is an object).

So either:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Thank you so much. I learned something new today with your explanation.