Sorting is ok:

and you can have empty columns.. just remember to ALWAYS keep a dummy
header in the first row.

a sheet is not by defintion an access table... you can have mnay
"tables" on a sheet.. which many of us find very usefull

when you sort Excel uses the CurrentRegion method (ctrl+*) to determine
the "list" it's working with.


there IS the UNDO options.. and it has quite a few steps. HAD you
checked your data you COULD have pressed ctrlZ after the sort and you'd
have had no problems.

it's not weird behaviour on Excel's part, it's your inexperience.

about migrating to access.. importing the data will take 5 secs, but
you'll probably have to rewrite quite a bit of your code...
and have to deal with the quirks of access :)


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Bruccce" wrote:

Main reason I posted to THIS NG was to see if there was a
logical/feasible way to create a rollback or history log or something.
something that when I change my data, it would get logged into a diff.
worksheet. That way I could always recreate the data.

It looks like we might have found the cuase of the issue. I do sort my
data (seems like this might not be the best thing to do) and some
times, I clear the contents of one or two of the columns. It appears
that Excel does not sort any of the stuff past an empty column??!!
Excel does do some WIERD things!


Any idea how hard it would be to migrate some of my custom code to
ACCESS? I think I might of had my fill with all of these weird issues!

Thanks,
Bruce