How to find current range used in cell validation with xlValidateList

I have several validation cells that are created using code like:

Please Login or Register  to view this content.

How can I then go in with VBA and see the value of formula1? I want something that will tell me "=AllocMethods" I have tried things that have not worked yet. I want to save the named range used so I can access it later and use this one again.

Please Login or Register  to view this content.

Thanks