-
I nthe first for the cross posting I did that for to reasons:
1- I didn't have a soulition on this forum.
2- I didn't understand how to send cross posting althouhg I read this article of cross postin http://www.excelguru.ca/node/7
I know you are nerveous because of my ignoring. I didn't ignore anything but as I told you. I'm so sorry, but may you help me please and tell me how to cross posting when I have like this problem it's mean what I must to do by this topic to make it cross posting.
the second:
I made some details on the code ( by add j counter to the output item), and it succeed with me.
[vba]
Dim mpStartRow As Long
Dim i As Long, j As Long
j = 1
mpStartRow = UsedRange.Cells(1, 1).Row
For i = 1 To UsedRange.Rows.Count
If Cells(mpStartRow - 1 + i, "C").Value = TextBox1.Text And _
Cells(mpStartRow - 1 + i, "D").Value = TextBox2.Text And _
Cells(mpStartRow - 1 + i, "E").Value = TextBox3.Text And _
Cells(mpStartRow - 1 + i, "F").Value = TextBox4.Text Then
Cells(j, "L").Value = Cells(mpStartRow - 1 + i, "A").Value
Cells(j, "M").Value = Cells(mpStartRow - 1 + i, "B").Value
Cells(j, "N").Value = Cells(mpStartRow - 1 + i, "G").Value
Cells(j, "O").Value = Cells(mpStartRow - 1 + i, "H").Value
Cells(j, "P").Value = Cells(mpStartRow - 1 + i, "I").Value
Cells(j, "Q").Value = Cells(mpStartRow - 1 + i, "J").Value
j = j + 1
End If
Next i
[/vba]
By the way xld why: mpStartRow and why mpStartRow - 1 + i
Thank you again for help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules