p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   VB How-To (http://p2p.wrox.com/forumdisplay.php?f=78)
-   -   trying to sort data in excel with vb.net (http://p2p.wrox.com/showthread.php?t=11057)

deanna March 26th, 2004 04:25 PM

trying to sort data in excel with vb.net
 
here's my code:

ExcelGlobal_definst.Range("a1:bo36").Sort(Key1:=(" a1:bo36"), Order1:=Excel.XlSortOrder.xlAscending, Header:=Excel.XlYesNoGuess.xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=Excel.XlSortOrientation.xlSortRows, DataOption1:=Excel.XlSortDataOption.xlSortNormal)

there are no compile errors, but while running the program tells me I have an error in this formula. I'm trying to sort range a1:bo36, ascending, according to column A.

TIA
deanna



All times are GMT -4. The time now is 08:21 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.