View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jgmiddel[_9_] jgmiddel[_9_] is offline
external usenet poster
 
Posts: 10
Default How to sort a selection of rows?

This code selects some rows in my sheet:

With Rng.Parent
.Select
.Range("B4", LastCell).Select
End With

The number of columns and rows are variable. I want to sort the rows.
How can I do it? I am working in Excel 2007.

Any help is welcome!!