+ Reply to Thread
Results 1 to 3 of 3

Simple Array Function help!

  1. #1
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,014

    Simple Array Function help!

    Greetings,
    I want to do following;
    A1----------B1------ C1------ D1--- E1
    England-Turkey-Germany-France-Italy

    I am running following code;
    Please Login or Register  to view this content.
    This is Macro1 result;
    A1----------B1------ C1------ D1--- E1
    England-England-England-England-England


    P.S: Using array function is must.

    Regards
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,997

    Re: Simple Array Function help!

    Please Login or Register  to view this content.

    Regards, TMS
    Last edited by TMS; 03-30-2015 at 05:51 PM.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,997

    Re: Simple Array Function help!

    Or:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Loop & Array (Probably Simple!)
    By B_B in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-14-2013, 10:50 PM
  2. Simple Array Problem
    By melvyn61 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2008, 06:47 PM
  3. simple DB function: trying sum & vlookup w/ array function
    By dlh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-04-2007, 02:51 PM
  4. Simple Array
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-24-2006, 08:41 PM
  5. [SOLVED] Simple Array Looping
    By Nikky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2005, 06:06 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