Results 1 to 4 of 4

Trouble Setting a Range

Threaded View

CJ944 Trouble Setting a Range 01-05-2012, 12:34 PM
Andrew-R Re: Trouble Setting a Range 01-05-2012, 12:40 PM
jaslake Re: Trouble Setting a Range 01-06-2012, 02:13 PM
CJ944 Re: Trouble Setting a Range 01-12-2012, 10:53 AM
  1. #1
    Registered User
    Join Date
    06-24-2010
    Location
    Newbury, England
    MS-Off Ver
    Excel 2003
    Posts
    19

    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))
    Last edited by CJ944; 01-12-2012 at 10:52 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1