View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_8_] Jon Peltier[_8_] is offline
external usenet poster
 
Posts: 70
Default Resize Dynamic Ranges

Don -

Yep, I've done that too. Laziness is the mother of invention.

- Jon

Don Guillett wrote:

Jon,

If you aren't aware of this idea maybe it will help for all the typing.
Just select one you have already donetype in a new nameselect the refers
to box<F2edit only what is necessary. This is how I usually do it so never
stumbled across your method.