Range("H12").Offset(7,6).Resize(3,2).Copy

--

HTH

RP
(remove nothere from the email address if mailing direct)


"cdavidson" wrote in message
...
Simply looking to understand how to properly apply the offset command to
identify a range in VBA coding. The respective portion of my 'improper'
code
is shown below. What should the 'Range("...' line of code be? Thanks!


Sub PivotConcept()

Sheets("Pivots").Select
Range("(OFFSET(R12C8,7,6,3,2)").Select
Selection.Copy

.
.
.

End Sub