Member Avatar for 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

  • 2 Contributors
  • 1 Reply
  • 106 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by mnemtsas
Member Avatar for mnemtsas

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:

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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.