MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

UsedRange and Sort

  Asked By: Gin    Date: Dec 14    Category: MS Office    Views: 3244

, I am a total beginner in Excel, I know well VB, but not VBA for
Excel, I don't know what is UsedRange... I try to figure out some code,
I have to debug it...

the statement is :

shtData.UsedRange.Sort Key1:=shtData.Range(fstrNomCol(colDestinataire)
& "1"), _
Key2:=shtData.Range(fstrNomCol(colTypeTrafic) & "1"), _
Key3:=shtData.Range(fstrNomCol(colHMin) & "1"),

Can anyone explain me what is Sort doing too?? I tried to read the help
online but microsoft is wee bit cryptic some times...



1 Answer Found

Answer #1    Answered By: Tasha Wheeler     Answered On: Dec 14

The UsedRange is the area of the worksheet that has data in it.
Sort will put the data in ascending or descending order (keys are
used to specify which column(s) or row(s) to sort  by).

Didn't find what you were looking for? Find more on UsedRange and Sort Or get search suggestion and latest updates.