$$Excel-Macros$$ Re: VBA Compare only visible rows

2014-04-30 Thread Benjamin Gilberg
ach y In CompareRange If whateverrow.Hidden = False Then If x = y Then x.Select Selection.EntireRow.Hidden = True End If Next y End If Next x End Sub On Wednesday, April 30, 2014 11:49:43 AM UTC-7, Benjami

Re: $$Excel-Macros$$ VBA Compare only visible rows

2014-04-30 Thread Benjamin Gilberg
ile with dummy data > > Regards > > Ashish koul > Sent on my BlackBerry® from Vodafone > -- > *From: * Benjamin Gilberg > > *Sender: * excel-...@googlegroups.com > *Date: *Wed, 30 Apr 2014 11:49:43 -0700 (PDT) > *To: *> > *ReplyTo:

$$Excel-Macros$$ VBA Compare only visible rows

2014-04-30 Thread Benjamin Gilberg
Hey everyone and thanks in advance for any help. I have a fairly simple macro, that worked wonders in my tiny test set, but is slogging along at an incredibly slow pace when I set it to run it's full scale application. The 'Cull_List' worksheet has already been filtered down somewhat from it's