Hi,

Indirect formula seems to be most helpful for this. If you could provide a direct example through a file or how the data looks like, it would make things easier to work out. For instance, are names alphabetically sorted so that you can have a continuous named range?

Vba has a referToRange method that also deals with named range...

Provide more information and I'll see

Pascal Baro