Hi,

Without an example of what your problem it's hard to guess.

Try this link which might help

http://www.contextures.com/xlNames01.html

Come back if it's not what your after

VBA Noob