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))
Bookmarks