Results 1 to 7 of 7

Error putting horizontal series of cells into array .....why?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,679

    Error putting horizontal series of cells into array .....why?

    I have the folllowing code which is supposed to put cells B2 through B25 into an array.


    month_array1 = ws.Range(Cells(2, 13), Cells(2, 25)).Value

    But it does not work............what does work is the following:


    month_array2 = ws.Range("B2:B25").Value


    but i dont know why the 2nd worked but the first did not? anyone have any ideas?
    Last edited by welchs101; 09-23-2011 at 10:37 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