ashwinghanta
Board Regular
- Joined
- Dec 6, 2011
- Messages
- 118
I want to test if the first letter of the cells in row 394 start with Q in sheet 6.and if so then mark x in those columns in row 552 in sheet 6 I am using the code
But I get x marked only for the first column of the row 552. Infact I placed Q in the first 20 cells of sh4.row 394. Where is it going wrong?
Code:
If Left(sh6.Cells(394, j), 1) = "Q" Then
sh2.Cells(552, j).Value = "x"
End If
But I get x marked only for the first column of the row 552. Infact I placed Q in the first 20 cells of sh4.row 394. Where is it going wrong?