Re: $$Excel-Macros$$ Fwd: Excel Macro : Sorting Based on Column Header

2010-04-30 Thread Sundarvelan N
on. > > I was responding to the question regarding sorting columns. > > Paul > > -- > *From:* Sundarvelan N > *To:* excel-macros@googlegroups.com > *Sent:* Fri, April 30, 2010 8:14:59 AM > *Subject:* Re: $$Excel-Macros$$ Fwd: Excel Macro : S

Re: $$Excel-Macros$$ Fwd: Excel Macro : Sorting Based on Column Header

2010-04-30 Thread Paul Schreiner
I'm sorry, I don't understand your question. I was responding to the question regarding sorting columns. Paul From: Sundarvelan N To: excel-macros@googlegroups.com Sent: Fri, April 30, 2010 8:14:59 AM Subject: Re: $$Excel-Macros$$ Fwd: Excel Macro

Re: $$Excel-Macros$$ Fwd: Excel Macro : Sorting Based on Column Header

2010-04-30 Thread Sundarvelan N
Hi Paul, Thanks for your reply. could you try my clue. That is find the column number and assign value to it. Thanks, Sundarvelan On Fri, Apr 30, 2010 at 5:01 PM, Paul Schreiner wrote: > Evidently, you're using Excel 2003, so the VBA sort command would look > different than mine in Excel2007.

Re: $$Excel-Macros$$ Fwd: Excel Macro : Sorting Based on Column Header

2010-04-30 Thread Paul Schreiner
Evidently, you're using Excel 2003, so the VBA sort command would look different than mine in Excel2007. I recommend that you record a macro, sort the sheet, then look at the code created. In Excel2007, it looks like: Sub SortData()     Cells.Select     ActiveWorkbook.Worksheets("Sample").Sort.