Excel Macro using vba :(

Expand Post »

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

Similar Threads

Execl: Computer Serial number with VBA in Visual Basic 4 / 5 / 6
Find Data in an Access Field from Excel Macro in Visual Basic 4 / 5 / 6
Simple Excel Macro (VBA) in Visual Basic 4 / 5 / 6
Excel Macro VBA Help in Visual Basic 4 / 5 / 6

Slade

Reputation Points: 115

Solved Threads: 7

Practically a Master Poster

Offline

633 posts
since Mar 2004

Permalink

Aug 19th, 2004

Re: Excel Macro using vba :(

Quote 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:

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

mnemtsas

Reputation Points: 16

Solved Threads: 1

Posting Whiz in Training

Offline

200 posts
since Jul 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: FIeld width zero?

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Datashet View

DaniWeb Message

Cancel Changes

User Name
Password