Re: $$Excel-Macros$$ Reverse Sorting Of Rows

2011-07-28 Thread Dilip Pandey
gt;>  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 Sor

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

2011-07-27 Thread qcan
e = 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@goo

RE: $$Excel-Macros$$ Reverse Sorting Of Rows

2011-07-26 Thread Rajan_Verma
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 iSt

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

2011-07-26 Thread Dilip Pandey
Hi, You can refer to following link by Microsoft - http://support.microsoft.com/kb/324991 Regards, DILIPandey On 7/27/11, XLS S wrote: > Dilip sir, > > i want to learn offset function, please provide the basic tips and example > > On Wed, Jul 27, 2011 at 9:59 AM, Dilip Pandey wrote: > >> Hi,

Fwd: $$Excel-Macros$$ Reverse Sorting Of Rows

2011-07-26 Thread NOORAIN ANSARI
lt;http://noorain-ansari.blogspot.com/> -- Forwarded message -- From: qcan Date: Wed, Jul 27, 2011 at 3:38 AM Subject: $$Excel-Macros$$ Reverse Sorting Of Rows To: MS EXCEL AND VBA MACROS Hi, A little different request here. I am looking for a way to reverse sort rows: Example:

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

2011-07-26 Thread XLS S
Dilip sir, i want to learn offset function, please provide the basic tips and example On Wed, Jul 27, 2011 at 9:59 AM, Dilip Pandey wrote: > Hi, > > You can use following formula in the next column and drag it down till > you have data. > > =OFFSET($A$1,COUNTA(A:A)-ROW(A1),0) > > Sample file is

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

2011-07-26 Thread XLS S
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)

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

2011-07-26 Thread Dilip Pandey
Hi, You can use following formula in the next column and drag it down till you have data. =OFFSET($A$1,COUNTA(A:A)-ROW(A1),0) Sample file is also attached. Regards, DILIPandey On 7/27/11, qcan wrote: > Hi, > > A little different request here. I am looking for a way to reverse > sort rows: > >

$$Excel-Macros$$ Reverse Sorting Of Rows

2011-07-26 Thread qcan
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