Clear a "moving" range offset from Target
Um.., clearly there's a flaw in the "CreateNames" routine because
code-selecting any given range selects all rows across all cols. What
gives with the RefersTo for the range names?
--
Garry
Can't answer that, was just using a code from a seemingly trusted site to make quick work of naming several ranges.
Best to scrap that and go with everything you use and know to work.
Howard
|