Referencing multiple ranges of a varying row

I've written a code in VB to sort through a main sheet and copy certain rows over to other sheets. I'm incrementing the sort with a variable i and for the one sheet, I don't want to copy the entire row. I wish for it to copy all except one column but can't seem to figure out the proper syntax. Please help.

The part of my code in question is:

For i = 10 To LastRow

If Sheets("Main").Range("C" & i).Value Like "*D*I*A*" Then
Sheets("Main").Cells(i, "C").EntireRow.Copy Destination:=Sheets("ROUND STOCK").Range("A" & Rows.Count).End(xlUp).Offset(1)

"EntireRow" is where I would like to place my ranges. Any ideas would help.

Thank you in advance!

Thank you very much, I found an alternative solution in the meantime but that's definitely good to know for the future