Results 1 to 20 of 20

Use range to fill an array

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-19-2010
    Location
    Calgary, Canada
    MS-Off Ver
    Office 2013, Office 365 Pro Plus
    Posts
    182

    Use range to fill an array

    I have an array I want to fill with a rane of cells from a worksheet. I can do this using

    dim myArray as variant
    
    With Workbooks("Book1").Worksheets("Sheet1")
    
    lastRow = .Range("A7").End(xlDown).Row    
    myArray = Range(.Cells(7, "A"), .Cells(lastRow, "A")).Value
    
    End With
    My question is can I use a similar technique to fill the array with strings instead of variants?
    Last edited by jlt199; 03-25-2010 at 12:52 PM.

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