If you have an earlier version of the file saved somewhere (perhaps
you emailed it to a user?), then you could use that to re-create the
sort order, even if the numbers have changed, as long as there is some
way of uniquely identifying each row in the original table and
relating that back to the table you now have.

Hope this helps.

Pete

On Oct 2, 3:19*pm, Vambo wrote:
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