Hi,
I'm trying to write some code that will create an alert when a
particular string value is found more than once in a specified range.
For exmple, in Col A i have:
cat
cat
cat
mouse
dog
dog
I need a script that will count how many times I have "cat" written
and if that value is >1 I want it t
-
> For I = 1 To RowCnt
> If Dict_CellVal.Item(Cells(I, "A").Value) > 1 Then
> Cells(I, "A").Interior.ColorIndex = 3
> End If
> Next I
> End Sub
>
> (did 10,000 rows in less than 1 second!)
>
> Paul
>
>
x27;ve attached a workbook for you to look at.
> Regards - Dave
>
>
>
> > Date: Fri, 11 Dec 2009 05:40:22 -0800
> > Subject: $$Excel-Macros$$ Alert for repeating cell information
> > From: gapp...@hotmail.com
> > To: excel-macros@googlegroups.com
>
> > H
A").Value) > 1 Then
Cells(I, "A").Interior.ColorIndex = 3
End If
Next I
End Sub
(did 10,000 rows in less than 1 second!)
Paul
________
From: ChrisInHolland
To: MS EXCEL AND VBA MACROS
Sent: Fri, December 11, 2009 8:40:22 AM
Sub
ook at.
Regards - Dave
> Date: Fri, 11 Dec 2009 05:40:22 -0800
> Subject: $$Excel-Macros$$ Alert for repeating cell information
> From: gapp...@hotmail.com
> To: excel-macros@googlegroups.com
>
> Hi,
>
> I'm trying to write some code that will create an alert w
> example:
> =COUNTIF($A$1:$A$2000,A1)>1
> I've attached a workbook for you to look at.
> Regards - Dave
>
>
> > Date: Fri, 11 Dec 2009 05:40:22 -0800
> > Subject: $$Excel-Macros$$ Alert for repeating cell information
> > From: gapp...@hotmail.com
> &
