Results 1 to 11 of 11

Concatenate array name

Threaded View

crimsontrooper Concatenate array name 07-22-2020, 06:59 AM
nigelog Re: Concatenate array name 07-22-2020, 07:27 AM
Sintek Re: Concatenate array name 07-22-2020, 08:22 AM
crimsontrooper Re: Concatenate array name 07-22-2020, 09:23 AM
nigelog Re: Concatenate array name 07-22-2020, 09:28 AM
Fluff13 Re: Concatenate array name 07-22-2020, 09:55 AM
nigelog Re: Concatenate array name 07-22-2020, 10:20 AM
Rick Rothstein Re: Concatenate array name 07-22-2020, 10:48 AM
crimsontrooper Re: Concatenate array name 07-23-2020, 12:16 AM
Rick Rothstein Re: Concatenate array name 07-23-2020, 12:31 AM
crimsontrooper Re: Concatenate array name 08-03-2020, 09:32 AM
  1. #1
    Registered User
    Join Date
    01-12-2015
    Location
    PL
    MS-Off Ver
    2016
    Posts
    29

    Concatenate array name

    Hi,
    I have four arrays named 1deg, 2 deg, 3 deg and 4deg.
    I would like to populate the contents of these arrays into range with a single loop i the following manner:
        For i = 4 To 1 Step -1
    
            Range(Cells(41 - i, 15), Cells(41 - i, 19)) = i&deg
        
        Next i
    However this returns only a string composed with the "i" value and word "deg". Is there a way to concatenate the array name, so that the output would be the array contentes not the "i"+"deg" string?

    Thanks in advance
    Regards
    Last edited by crimsontrooper; 07-22-2020 at 07:02 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using Concatenate and Array into one List
    By Excell1677 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-17-2016, 05:01 AM
  2. Concatenate / Array Help
    By burgie10 in forum Excel General
    Replies: 5
    Last Post: 09-05-2015, 05:07 AM
  3. =CONCATENATE within an array
    By gassiusmax in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-02-2015, 12:22 PM
  4. How To Concatenate an Array?
    By Camel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2013, 05:01 AM
  5. Variable name concatenate with array
    By Bmoe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2010, 07:20 AM
  6. Array Formula - Concatenate
    By Lotus123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2006, 10:36 PM
  7. Concatenate an array
    By Ed in forum Excel General
    Replies: 4
    Last Post: 07-03-2006, 01:00 PM

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