Trouble Setting a Range

Hello All,

I know it's something really basic, but I'm having trouble using a range at the start of my macro. It's something to do with the way I'm referencing it I just can't seem to see the answer at the moment. I get a 'Run-time error 1004: Application-defined or object-defined error' on the final row of the code below. Any help would be very gratefully received.

Many thanks in advance for any help,
C Jones

Private Sub Details_Click()

Dim LastRow As Long
Dim myList As Range
Dim SOBK As Workbook
Dim NewBK As Workbook

'Application.ScreenUpdating = False
Set SOBK = ActiveWorkbook
LastRow = Worksheets("Manugistics Chnl_FC_RD").Range("G1").End(xlDown).Row
Set myList = Worksheets("Manugistics Chnl_FC_RD").Range(Cells(2, 7), Cells(LastRow, 7))

Hi CJ944
This line of code should work

Set myList = Worksheets("Manugistics Chnl_FC_RD").Range("G2:G" & LastRow)