Re: $$Excel-Macros$$ modify a macro to have startCol and endCol

2014-09-02 Thread Pramod Singh
Hi Bill PFA... On Wed, Sep 3, 2014 at 10:55 AM, Mr_Bill wrote: > I appreciate the effort but that doesnt work correctly. > > > On Tuesday, September 2, 2014 8:52:50 PM UTC-7, pramodb35 wrote: > >> Hi Bill >> >> Please find the attached fi

Re: $$Excel-Macros$$ modify a macro to have startCol and endCol

2014-09-02 Thread Mr_Bill
I appreciate the effort but that doesnt work correctly. On Tuesday, September 2, 2014 8:52:50 PM UTC-7, pramodb35 wrote: > > Hi Bill > > Please find the attached file . > > > P > > > On Wed, Sep 3, 2014 at 1:17 AM, Mr_Bill > > wrote: > >> I currently have a macro that works for columns 1:

Re: $$Excel-Macros$$ modify a macro to have startCol and endCol

2014-09-02 Thread Pramod Singh
Hi Bill Please find the attached file . P On Wed, Sep 3, 2014 at 1:17 AM, Mr_Bill wrote: > I currently have a macro that works for columns 1:5 > > I would like to know how would I make the script work with columns 7:11 > with 10 being the sortKeyCol. > > Not sure what I need to chang

$$Excel-Macros$$ modify a macro to have startCol and endCol

2014-09-02 Thread Mr_Bill
I currently have a macro that works for columns 1:5 I would like to know how would I make the script work with columns 7:11 with 10 being the sortKeyCol. Not sure what I need to change in the code itself to make it work. Could someone lend a hand with this please. Here is a stripped down ver