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