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
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
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.
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.