How to use a Define Name variable in VBA procedure

I have a Define Name variable in one of my worksheets. It's called Cur_Month. I want to use it in my VBA procedure. I tried to use something like

i = Cur_Month

but it did not recognize Cur_Month.

Thanks.

Hi,

Do you mean you have define a named range in one of your worksheets?

if yes, you will need to define a Range type variable in the VBA procedure and set it to the named range:

Please Login or Register  to view this content.

Thanks,
Excelfandoo