$$Excel-Macros$$ Filter Data of Bold letter

2013-09-11 Thread Ashish Bhalara
Dear experts, I have a data columnar and want filter only bold letter data, is it possible, if yes please tell me how it done. Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you

Re: $$Excel-Macros$$ Filter Data of Bold letter

2013-09-11 Thread अनिल नारायण गवली
Dear Ashish, Pl share the workbook with us. Warm Regards, Gawli Anil. Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Sep 11, 2013 at 1:20 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I have a data columnar and want

Re: $$Excel-Macros$$ Filter Data of Bold letter

2013-09-11 Thread xlstime
Hi, Please read below link http://support.microsoft.com/kb/213923 . Enjoy Team XLS On Wed, Sep 11, 2013 at 1:20 PM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear experts, I have a data columnar and want filter only bold letter data, is it possible, if yes

Re: $$Excel-Macros$$ Filter Data of Bold letter

2013-09-11 Thread अनिल नारायण गवली
Dear Ashish, Pl see the attached workbook. Is it ok? Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Sep 11, 2013 at 2:11 PM, अनिल नारायण गवली gawlianil8...@gmail.com wrote: Dear Ashish, Pl share the workbook with

Re: $$Excel-Macros$$ Filter Data of Bold letter

2013-09-11 Thread Prafull Jadhav
Dear Anil and Xlstime Sir, can we use below method? Sub prafull() For Each x In Range(G2:G139) If x.Font.Bold = True Then x.Offset(0, 1).Value = 1 End If Next x End Sub On Wed, Sep 11, 2013 at 2:23 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Ashish, Pl see the attached

Re: $$Excel-Macros$$ Filter Data of Bold letter

2013-09-11 Thread Ashish Bhalara
Thanks Mr.Anil others I got it. On Wed, Sep 11, 2013 at 5:36 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear Anil and Xlstime Sir, can we use below method? Sub prafull() For Each x In Range(G2:G139) If x.Font.Bold = True Then x.Offset(0, 1).Value = 1 End If Next x End Sub