I need to copy data from 1 worksheet and paste it in a
different worksheet. the range will always start with
cell C3 and end with a cell in column I. The number of
rows vary. How can I accomplish this? Here's what i have
so far:

Dim lngLastRow As String
Dim myStartColumn, myEndColumn As String

lngLastRow = myDataSheet.UsedRange.Rows.Count
myStartColumn = 3
myEndColumn = myStartColumn + 7

???

Any help will be appreciated.
MDC