Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What's wrong with this code, please?
I have 4 columns with data in them. I first check to see if two cells match.
If so, I want to fill in the value of a cell in a third column with the corresponding value from a 4th Column. Nothing happens... For i = 5 To numberofRows If Cells(i, 111).Value = Cells(12, j).Value Then Cells(k, j).Value = Cells(i, 112).Value k = k + 1 End If Next Help would be appreciated. BTW, thanks to those who have assisted in previous requests. Jim Berglund |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What's wrong with this code, please?
Cells(i,111).Value never equals Cells(12,j)
j never gets initialized and you are using On Error Resume Next, so you never see the error k is never initialized and you are using On Error Resume Next, so you never see the error. Just some possibilities. -- Regards, Tom Ogilvy "Jim Berglund" wrote in message ... I have 4 columns with data in them. I first check to see if two cells match. If so, I want to fill in the value of a cell in a third column with the corresponding value from a 4th Column. Nothing happens... For i = 5 To numberofRows If Cells(i, 111).Value = Cells(12, j).Value Then Cells(k, j).Value = Cells(i, 112).Value k = k + 1 End If Next Help would be appreciated. BTW, thanks to those who have assisted in previous requests. Jim Berglund |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is wrong with this code? | Excel Discussion (Misc queries) | |||
What is wrong with this code? | Excel Discussion (Misc queries) | |||
What's wrong w/my code? | Excel Programming | |||
Can someone tell me what's wrong with this code please? | Excel Programming | |||
What is wrong with this code? | Excel Programming |