Macro code to change cell range to named range

I need to change my macro code so the macro will use a range based upon a name I've given it (insert -> Name->Define), instead of a fixed cell range. Currently my code is as follows:

Please Login or Register  to view this content.

The range in the sample is 754:817. I need it to just look up a name range that has those cells, like the range list1, for example. Any help is appreciated.

If you don't understand what I'm asking for then please reply and I'll clarify.

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Also, please remember to use Code Tags in future