How to copy until the end of the row from the middle of the row

[vpan16]

If I have a loop going through a column, and if there is a count for each row and when teh count is greater than 0, I want to copy everything from the Col C to the end of the row (can vary from row to row).

I know how to copy the whole row, but how can I copy the data only starting from the 3rd column?

 

[steve the fish]

Heres an example of how to do that:

Set sh = Sheets("Sheet1")
i = 1
With sh
    Range(.Cells(i, 3), .Cells(i, Columns.Count)).Copy
End With