Thread: How to soft a selected range of data in Excel by using VB.Net
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chan Ho Seng Chan Ho Seng is offline
external usenet poster
  
Posts: 1
Default How to soft a selected range of data in Excel by using VB.Net
I'm facing a problem, I can't be able to sort a selected
range of data when I use this command in VB.Net.

Worksheet.UsedRange.Sort("A15",
XlSortOrder.xlAscending, "B15", ,
XlSortOrder.xlAscending, "C15", XlSortOrder.xlAscending,
XlYesNoGuess.xlYes, 1, False,
XlSortOrientation.xlSortColumns, XlSortMethod.xlPinYin)

is this command any wrong? please help me, thanks


Reply With QuoteReply With Quote