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.
Bookmarks