RE: $$Excel-Macros$$ Sort and then extract digits from 7 to 25

2010-08-02 Thread Dave Bonallack
h 1000 formulas. Regards - Dave. Date: Sun, 1 Aug 2010 11:49:27 -0400 Subject: $$Excel-Macros$$ Sort and then extract digits from 7 to 25 From: skanda.pokkun...@gmail.com To: excel-macros@googlegroups.com Hi All, The report that I generate is sorted on column "S" and then it is hidden

$$Excel-Macros$$ Sort and then extract digits from 7 to 25

2010-08-01 Thread Skanda
Hi All, The report that I generate is sorted on column "S" and then it is hidden using VBA code.After the sorting is done I want to display only characters from 7 to 25 from row b6 to B1000. Eg. PM 00 New York,NY. We need to diaplay only New York,NY.How to do this programatically? Tha