Hi All,
Could you please help me with the below, I can copy the row and paste it but only staring from first column in the new sheet.
Is there any other way to start pasting from, let's say the second column
THe code excerpt:
For counter= 2 To number_rows_check
If Yest.Cells(counter, 3).Value = Db.Range("A4") And Yest.Cells(licznik, 9).Value = Db.Range("B4") And IsError(Yest.Cells(counter, 11)) Then
Rows(counter).Copy
Comp.Rows(curr_position + 2).PasteSpecial Paste:=xlPasteValues
End If
Next counter
Thanks for help
Gregor Olaf
Bookmarks