I'm trying to create a macro that will do the following:
When the user changes a value or values in column 'B', the macro will
iterate through all cells in columns 'C' to 'AO' but only in the same
row(s) that were changed in column 'B'.
So basically, whatever row or rows got changed, those same rows but
columns C to AO will be altered. The macro is actually just applying
some simple formatting to those cells.
Here's what I have so far and it fails on 'theRow = Target.Rows(i)':
Excerpt
*****************************************************************
Dim theCell As Range
Dim theRow As Range
Dim i As Integer
For i = 1 To Target.Rows.Count
theRow = Target.Rows(i)
For Each theCell In Intersect(Range("C1:AO35"), theRow)
If theCell.Value > 0 Then
'Is a multiple of 6 - GOLD
If theCell.Value Mod 6 = 0 Then
Call setGold(theCell)
Else
'Is a multiple of 3 but not a multiple of 6 - SILVER
If (theCell.Value Mod 3) = 0 Then Call setSilver
(theCell)
End If
End If
Next theCell
Next i
****************************************************************************
Why can't I just iterate through a Rows collection?
Any help would be appreciated!
Mark
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
