How would I skip pasting in a cell when pasting from a different worksheet. Where the ? mark is where I want to skip pasting in that cell.
![]()
xlWsTarget.Range(xlWsTarget.Cells(eRow, 1), xlWsTarget.Cells(eRow, 7)).Value = _ Array(.Cells(x, 1).Value, _ .Cells(x, 9).Value, _ .Cells(x, 4).Value, _ .Cells(x, 7).Value, _ .Cells(x, 12).Value, _ .Cells(x, ?).Value, _ .Cells(x, 22).Value)
Bookmarks