DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

Excel Macro using vba :(

•

Join Date: Mar 2004

Posts: 634

Reputation: Slade has a spectacular aura about

Solved Threads: 7

Slade

Offline

Practically a Master Poster

Excel Macro using vba :(

Aug 18th, 2004

hey guys... I want to be able to auto sort rows ascending in a worksheet according to the first column... I want to make a visual basic macro for this... any ideas?

Thanks in advance

Formerly known as Slade.

•

Join Date: Jul 2004

Posts: 200

Reputation: mnemtsas is an unknown quantity at this point

Solved Threads: 1

mnemtsas

Offline

Junior Poster

Re: Excel Macro using vba :(

Aug 19th, 2004

•

Originally Posted by slade

hey guys... I want to be able to auto sort rows ascending in a worksheet according to the first column... I want to make a visual basic macro for this... any ideas?

Thanks in advance

Try recording the macro, that's how I taught myself VB to begin with. here's the code from me recording a sort:

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 19/8/2004 by Mark Nemtsas
'
 
'
    Columns("A:D").Select
    Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 19/8/2004 by Mark Nemtsas
'

'
    Columns("A:D").Select
    Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub