Thread: Explain code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Novice Lee Novice Lee is offline
external usenet poster
 
Posts: 36
Default Explain code

Could someone explain the following code for me I'm new VBA and have never
seen some of these Items

Thanks

With Sheets(3)

LastRow = .Range("A" & Rows.Count).End(xlUp).Row
Set SortRange = .Rows("2:" & LastRow)
SortRange.Sort _
Key1:=Range("A2"), _
Order1:=xlAscending, _
Key2:=Range("C2"), _
Order2:=xlAscending, _
Header:=xlNo
End With