Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What's Wrong?
I'm trying to color the background of a row if a certain
set of conditions exists. I don't know what's wrong with this: For i = rng.Row To 1 Step -1 If Cells(i, 9).Value = Cells(i - 1, 10).Value _ And Cells(i, 10).Value = Cells(i - 1, 9).Value _ And Cells(i, 1).Value = Cells(i - 1, 1).Value _ And Cells(i, 2).Value = Cells(i - 1, 2).Value _ Then Cells(i, 1).EntireRow.Interior.ColorIndex = 35 end if Next I've tried taking out the "end if", including just "end", but nothing works??? I get a 1004 error. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What's Wrong?
Hi
just remove the 'End if' statement -- Regards Frank Kabel Frankfurt, Germany "Pam" schrieb im Newsbeitrag ... I'm trying to color the background of a row if a certain set of conditions exists. I don't know what's wrong with this: For i = rng.Row To 1 Step -1 If Cells(i, 9).Value = Cells(i - 1, 10).Value _ And Cells(i, 10).Value = Cells(i - 1, 9).Value _ And Cells(i, 1).Value = Cells(i - 1, 1).Value _ And Cells(i, 2).Value = Cells(i - 1, 2).Value _ Then Cells(i, 1).EntireRow.Interior.ColorIndex = 35 end if Next I've tried taking out the "end if", including just "end", but nothing works??? I get a 1004 error. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
What's Wrong?
For i = rng.Row To 1 Step -1
If Cells(i, 9).Value = Cells(i - 1, 10).Value _ And Cells(i, 10).Value = Cells(i - 1, 9).Value _ And Cells(i, 1).Value = Cells(i - 1, 1).Value _ And Cells(i, 2).Value = Cells(i - 1, 2).Value _ Then Cells(i, 1).EntireRow.Interior.ColorIndex = 35 end if Next or For i = rng.Row To 1 Step -1 If Cells(i, 9).Value = Cells(i - 1, 10).Value _ And Cells(i, 10).Value = Cells(i - 1, 9).Value _ And Cells(i, 1).Value = Cells(i - 1, 1).Value _ And Cells(i, 2).Value = Cells(i - 1, 2).Value _ Then Cells(i, 1).EntireRow.Interior.ColorIndex = 35 Next Both compile fine for me. However, I assume this is part of a larger procedure, so it could be affected by code I can not see. -- Regards, Tom Ogilvy "Pam" wrote in message ... I'm trying to color the background of a row if a certain set of conditions exists. I don't know what's wrong with this: For i = rng.Row To 1 Step -1 If Cells(i, 9).Value = Cells(i - 1, 10).Value _ And Cells(i, 10).Value = Cells(i - 1, 9).Value _ And Cells(i, 1).Value = Cells(i - 1, 1).Value _ And Cells(i, 2).Value = Cells(i - 1, 2).Value _ Then Cells(i, 1).EntireRow.Interior.ColorIndex = 35 end if Next I've tried taking out the "end if", including just "end", but nothing works??? I get a 1004 error. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is wrong with my UDF | Excel Discussion (Misc queries) | |||
What am I doing wrong? | Charts and Charting in Excel | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
What am I doing wrong? | New Users to Excel | |||
What am I doing wrong? | Excel Discussion (Misc queries) |