THANK YOU EVERYONE. I am in awe with the knowlege you guys have. WELL DONE !
On Jul 27, 2:25 am, "Rajan_Verma" <rajanverma1...@gmail.com> wrote: > Try this.. > > Sub Reverse() > > Dim fRng As Range > > Dim Couter As Integer > > Dim cell As Range > > Set fRng = Application.InputBox("Please Choose A Range", , , , , , , 8) > > Set cell = Application.InputBox("Please Choose a Cell for Output", , , , > , , , 8) > > cell.Activate > > For counter = fRng.Cells.Count To 1 Step -1 > > ActiveCell.Value = fRng.Cells(counter, 1) > > ActiveCell.Offset(1, 0).Select > > Next > > End Sub > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of XLS S > Sent: Wednesday, July 27, 2011 10:01 AM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Reverse Sorting Of Rows > > Try this.... > > Sub FlipRows() > Dim vTop As Variant > Dim vEnd As Variant > Dim iStart As Integer > Dim iEnd As Integer > Application.ScreenUpdating = False > iStart = 1 > iEnd = Selection.Rows.Count > Do While iStart < iEnd > vTop = Selection.Rows(iStart) > vEnd = Selection.Rows(iEnd) > Selection.Rows(iEnd) = vTop > Selection.Rows(iStart) = vEnd > iStart = iStart + 1 > iEnd = iEnd - 1 > Loop > Application.ScreenUpdating = True > End Sub > > On Wed, Jul 27, 2011 at 3:38 AM, qcan <comeonove...@gmail.com> wrote: > > Hi, > > A little different request here. I am looking for a way to reverse > sort rows: > > Example: > > ABC123 > ABC493 > ABC961 > > Would become sorted in decending order as: > > ABC961 > ABC123 > ABC493 > > Thanks. > > -- > ---------------------------------------------------------------------------- > ------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/discussexcel > > -- > ......................... > > -- > ---------------------------------------------------------------------------- > ------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel