Cheers. .
Thanks,
DILIPandey
On 7/28/11, qcan <comeonove...@gmail.com> wrote:
> 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
>
--
Sent from my mobile device
Thanks & Regards,
DILIP KUMAR PANDEY, mvp
MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
--
----------------------------------------------------------------------------------
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
