kkarre
10/12/2007 10:17:00 AM
Hello all,
I'm working on a vsto 2005 solution (also posted in Excel.programming but it
might
be an interop issue)
It regards sorting on an Excel worksheet:
I'm trying to sort a range on a column containing some empty cells (to get
them last
and later get rid of these rows)
Sheet like this:
Header1 Header2 Header3 Header4 etc.
1 qw xxx
2 qw 123456 yyy
3 qw 234567 zzz
4 er aaa
5 er 345678 bbb
Range("A1:W" & LastRow).Sort(Range("C1"))
doesn't seem to do the trick.
Sometimes nothing happens, sometimes it sorts the columns although
sorting rows is default!
Any code that DOES sort a range's rows on the third column would be greatly
appreciated!
/kk