column and row autocorrect?

[dr chuck]

i have made an elaborate xls file that performs multileveled sorts and pre
defined selections of data. The columns and rows of my data are defined in
my macros (ie perform blah blah blah at A6... etc).

Lack of forethought has led me to want to add additional columns and or rows
which will offset the cell address where my macro should function. For
example what was in A6 may now be located in D10.

is there a way to make my macro auto correct for addition of columns or
rows? Do i just have to re-code the macro with the specific addresses after
changes are made?

any thoughts would be greatly appreciated .

--
dr chuck

[Jim Thomlinson]

There is no easy way out of this one. The best idea is to reference named
ranges in your macros. That way if you add rows or columns then the macros
will be unaffected since the named ranges will be moved.
--
HTH...

Jim Thomlinson


"dr chuck" wrote:

> i have made an elaborate xls file that performs multileveled sorts and pre
> defined selections of data. The columns and rows of my data are defined in
> my macros (ie perform blah blah blah at A6... etc).
>
> Lack of forethought has led me to want to add additional columns and or rows
> which will offset the cell address where my macro should function. For
> example what was in A6 may now be located in D10.
>
> is there a way to make my macro auto correct for addition of columns or
> rows? Do i just have to re-code the macro with the specific addresses after
> changes are made?
>
> any thoughts would be greatly appreciated .
>
> --
> dr chuck

[dr chuck]

hey jim,
Thanks for the info. I am unfamilair with named ranges but i have found some
information to begin understanding them.
--
dr chuck


"Jim Thomlinson" wrote:

> There is no easy way out of this one. The best idea is to reference named
> ranges in your macros. That way if you add rows or columns then the macros
> will be unaffected since the named ranges will be moved.
> --
> HTH...
>
> Jim Thomlinson
>
>
> "dr chuck" wrote:
>
> > i have made an elaborate xls file that performs multileveled sorts and pre
> > defined selections of data. The columns and rows of my data are defined in
> > my macros (ie perform blah blah blah at A6... etc).
> >
> > Lack of forethought has led me to want to add additional columns and or rows
> > which will offset the cell address where my macro should function. For
> > example what was in A6 may now be located in D10.
> >
> > is there a way to make my macro auto correct for addition of columns or
> > rows? Do i just have to re-code the macro with the specific addresses after
> > changes are made?
> >
> > any thoughts would be greatly appreciated .
> >
> > --
> > dr chuck