VBA Excel 2010 How to Sort a Range or List using VBA

VBA Excel 2010 How to Sort a Range or List using VBA
Handy Excel Resources
amzn.to/3gFx7s1 - Excel Formulas & Functions For Dummies 5th Edition
amzn.to/3sYnuH6 - Microsoft Excel 2019 VBA and Macros
amzn.to/2PqXhU0 - MICROSOFT EXCEL VBA AND MACROS FOR BEGINNERS:
amzn.to/3xtsLtM - Microsoft Excel VBA Programming for the Absolute Beginner
amzn.to/3xwkEg0 - Excel 2019 Bible
amzn.to/3aJEHxW - EXCEL 2020 FOR BEGINNERS
As an Amazon Associate, I earn from qualifying purchases. Product prices and availability are subject to change.

[@kirankumarsukumar]

Exactly what i was searching for. Thanks a Lot. The Video Tutorial was TopClass.

[@carolynlee3856]

Hello, would it be possible to discuss engaging your services?

[@weihau2112]

I also use recording macro but why my code will select a Range? If my range changes to more than 26 rows, the macro will not be able to run right?
Sub filter2()
'
' filter2 Macro
'
'
Range("B2").Select
ActiveSheet.Range("$A$2:$K$26").AutoFilter Field:=2, Criteria1:="#N/A"
End Sub

[@b112895]

Wow didn't even know how to use 'Record a Macro' feature' thanks!

[@GopalKumar-po9vw]

thanks a lots for explain in very simple way

[@sfa20]

or insert the data as a table and just use "Range("A2").Sort Key1:=Range("g2"), Order1:=xlAscending, Header:=xlYes"

[@romybasant]

Excellent!!

[@TheYousafshah]

How i can use it in excel 2007.

[@allabout1135]

Thanks Sir for missing piece of puzle. Strong handshake from my side.

[@nazefali3699]

Hi dear friend, you have excellent knowledge of VBA, I learned a lot from your videos. i dont know how to thank you! could you please create a userform,and the userform contain patient details, for ex. first name, date of birth, female or male, what the problem with the patient, and so on, and then transfer all the information into a worksheet, this project for a small hospital in mycountry, very poor country!
god bless you, thank you so much.

[@mikebenstead9801]

' Clear Filter - top row
Rows("1:1").Select
With Activesheet
.AutoFilterMode = False
.range("1:1").AutoFilter
End With