If this code copies row 8 from sheet 1 to sheet 2, I would like it to copy
C8:J8
instead.
Dim rng As Range, r As Long
r = 8 ' Your Row #
Set Rng = Range("C" & r & ":J" & r)
Also instead of deleting row 8 in sheet 1, I would prefer if I could get it to Clear the content of C8:J8 in sheet 1.
Pegue o mesmo objeto rng
acima:
rng.ClearContents