No! Excel will automagically update the ref for you!



--

Garry


How does Excel know I decided I want col G instead of col A?

Howard

When you design the name Excel creates absolute refs ($) by default.
When you move the range, Excel updates the absolute refs to the new
location. This has been standard behavior for as far back as I can
remember!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion