Now I get it! Sometimes I am a little slow.

I don't think you will be able to create a dynamic range. Interesting idea. If you could, I thiink it would be about as complicated as the VBA code.