V
Vambo
I have a spreadsheet with VBA behind it which expects to find rows in a
certain order, once a key row is found (in column a) the following rows are
read as associated data until a new key row is encountered or the rows end.
The problem is that someone (no names) has applied a sort on column B which
means that all key rows are grouped together followed by all associated rows.
How can I 'switch off' the sort ? Or will I have to recreate the spreadsheet
from scratch ?
Any help appreciated
Thanks
V
certain order, once a key row is found (in column a) the following rows are
read as associated data until a new key row is encountered or the rows end.
The problem is that someone (no names) has applied a sort on column B which
means that all key rows are grouped together followed by all associated rows.
How can I 'switch off' the sort ? Or will I have to recreate the spreadsheet
from scratch ?
Any help appreciated
Thanks
V