Results 1 to 10 of 10

How to put range into redimed array?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,946

    How to put range into redimed array?

    Hi,

    i have code like here:

    Sub test()
    
      Dim a() As String
      
      ReDim a(1 To 6, 1 To 5)
      
      Dim rng As Range
      
      Set rng = ActiveSheet.Range("A2:E7")
      
      a = rng
    
    End Sub
    which throws an error about type.

    It is possible to assign to string array range?
    Or i have to loop?

    the purpose to have array as string it to not loose leading zeros while outputting variant array.

    Thanks!,
    Best,
    Jacek
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Evaluate Array then imput into range adjusting forumla in Array down with the Range
    By fireguy7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2019, 03:40 PM
  2. Countifs on an Array Range using multiple criteria in an Array
    By Mysore in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2016, 04:39 PM
  3. [SOLVED] Help with: Range Array SelectCase Loop delete: Array All Sheet.Names
    By dlow in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-08-2015, 07:11 PM
  4. Can I make the row lookup array/range part in an array formula variable?
    By OLLY-7 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-18-2014, 09:06 AM
  5. [SOLVED] Populate one array from another array and print new array as a range
    By Kaden265 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2014, 07:52 AM
  6. [SOLVED] Add Range to Array find Array value and Paste back to Range
    By Foreverlearning in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-28-2012, 05:45 PM
  7. Does filling part of an array from a range re-dimension the array?
    By barryleajo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-04-2011, 10:09 AM

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