Results 1 to 2 of 2

Noob! sort growing database with vba macro

Threaded View

pbecks1963 Noob! sort growing database... 12-14-2011, 05:06 AM
pbecks1963 Re: Noob! sort growing... 12-14-2011, 05:36 AM
  1. #1
    Registered User
    Join Date
    12-14-2011
    Location
    dfsdfg
    MS-Off Ver
    Excel 2010
    Posts
    2

    Noob! sort growing database with vba macro

    Hello to all,

    I am a complete Noob with vba. (i know excel though). I need to sort a database in excel 2010 using a vba macro. I have got this so far..

    **********************************
    Sub Macro12()
    '
    ' Macro12 Macro
    '

    '
    Range("A1:F1").Select
    Range(Selection, Selection.End(xlDown)).Select

    ' Here should come a string which sorts the ever changing above selection on header A1 and E1

    Selection.End(xlDown).Select

    End Sub
    ***********************************

    Now all this does is select the (ever growing) database-cells (filled cells). Next is: sorting the thing (first on header A1 and then on header E1). After that i need to jump to the last filled cell in column A. Then the macro should end.

    Can someone please help or point me in the right direction??

    ps: just to be clear about it. In the first row are headers ('fieldnames') and there is a 'autofilter' on that row.
    Last edited by pbecks1963; 12-14-2011 at 05:17 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1