Hi All,
I have a set of cells that I want to sort within a macro. I want these to be sorted ascending but some of the cells contain "" to enable me to have blank looking cells. When I sort the cells the ones with "" come before those beginnign with A. Is there a way to avoid this?
This is the code I have currently.
Thanks
Please Login or Register to view this content.
dvent
They come after the last ones, do they not?
A--qwerty
B--home
""--Friend
D--People
End up in
A--qwerty
B--home
D--People
""--Friend
Last edited by rwgrietveld; 12-10-2008 at 07:40 AM.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
it seems that if i enter ="" manually, these cells end up at the bottom.
but when "" is enterred into the cells by a previous macro, they stay at the top of the list. very strange?!
NOTE that ="" is not the same as a blank cell.
See this:
?ASC("=""")
61
?ASC("a")
97
?ASC("A")
65
?ASC("Z")
90
?ASC("z")
122
The ASCI code of a blank does not exists and therefore it is placed at the bottom.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks