mperrah
09-04-2007, 12:17 PM
I have an array named for use in a macro
The contents change constantly.
If I name the entire column, my code runs slow.
I would like to use offset to update values of the name as the data changes
The array is:
=library!$Q$3:$W$69
I have a single dynamic column named this:
=OFFSET(library!$Q$3,0,0,COUNTA(library!$R:$R)-2)
I'm not sure how to add multiple columns in the offset declaration..
Any ideas?
Thanks in advance,
Mark
The contents change constantly.
If I name the entire column, my code runs slow.
I would like to use offset to update values of the name as the data changes
The array is:
=library!$Q$3:$W$69
I have a single dynamic column named this:
=OFFSET(library!$Q$3,0,0,COUNTA(library!$R:$R)-2)
I'm not sure how to add multiple columns in the offset declaration..
Any ideas?
Thanks in advance,
Mark