Wow, I like this VBA example quite a bit, the problem I provided was
indeed simplistic and would need to be modified for my intended need.
I'm fairly new at VBA and very much appreciate your skill and
knowledge. I was wondering if an array was the way to go! Thank you
Again!
On Feb 2, 3:51 am, s
Very easy to understand, and just what I needed. Thank you very much
for your time and knowledge!
On Feb 2, 12:40 am, ashish koul wrote:
> see if this helps
>
> Sub sort1()
>
> Sheets(1).Range("a1:a" & Range("a1").End(xlDown).Row).Sort
> key1:=Sheets(1).Range("a:a"), order1:=xlAscending, Header:
see if this helps
Sub sort1()
Sheets(1).Range("a1:a" & Range("a1").End(xlDown).Row).Sort
key1:=Sheets(1).Range("a:a"), order1:=xlAscending, Header:=xlYes
Sheets(1).Range("b1:b" & Range("b1").End(xlDown).Row).Sort
key1:=Sheets(1).Range("b:b"), order1:=xlAscending, Header:=xlYes
Dim i As Long
For i
