Re: $$Excel-Macros$$ Iterating Filtered list using VBA

Nice Solution Vaibhav Sir Regards Ashish On 12 January 2015 at 20:05, Vaibhav Joshi wrote: > Cheers Nitin & appreciate your acknowledgement! > ᐧ > > On Mon, Jan 12, 2015 at 7:32 PM, Nitin Balodi > wrote: > >> Hi Vaibhav, >> >> Many thanks, code worked. >> >> >> Regards. >> >> Yours Sincerely,

Re: $$Excel-Macros$$ Iterating Filtered list using VBA

.@vabs.in > Date: Mon, 12 Jan 2015 15:45:33 +0530 > Subject: Re: $$Excel-Macros$$ Iterating Filtered list using VBA > To: excel-macros@googlegroups.com > > > Hi Nitin, > > Browsing thru filtered cell you can use following code: > > *Sub loop_filt_rng()* > *Dim rng

RE: $$Excel-Macros$$ Iterating Filtered list using VBA

Hi Vaibhav, Many thanks, code worked. Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in Date: Mon, 12 Jan 2015 15:45:33 +0530 Subject: Re: $$Excel-Macros$$ Iterating Filtered list using VBA To: excel-macros@googlegroups.com Hi Nitin, Browsing thru filtered cell you can use following code

Re: $$Excel-Macros$$ Iterating Filtered list using VBA

Hi Nitin, Browsing thru filtered cell you can use following code: *Sub loop_filt_rng()* *Dim rng as Range, c as Range* *ActiveSheet.Range("$A$1:$R$1").AutoFilter Field:=10, Criteria1:="Nitin", Operator:=xlOr, Criteria2:="Balodi"* *Dim c As Range, rng As Range* *Set rng = Range("A2", Range("A2").E

$$Excel-Macros$$ Iterating Filtered list using VBA

Hi Experts, I am writing a code and having issues in moving through rows in the filtered list. I have written the below code by searching on internet but it isn't working. Please help. Sub ScanningFilteredList() Dim CountValue As IntegerDim CopyCell ActiveSheet.Range("$A$1:$R$1").AutoFilter Field