+ Reply to Thread
Results 1 to 4 of 4

copy again the array in the first empty cell

  1. #1
    Forum Contributor
    Join Date
    05-30-2013
    Location
    Isreal
    MS-Off Ver
    Excel 2010
    Posts
    191

    copy again the array in the first empty cell

    I have a VBA code that copies a array and store the array in a value named "Arr_photo"
    Then copies the range of values in a new workbook.
    After the new workbook is formed I would like to copy again the array in the first empty cell after the first array that was copied that way I will have the same array twice one after each other.


    Here is the code I am using which is not working correctly.
    Please Login or Register  to view this content.

    Here is the full code for the sub.
    Please Login or Register  to view this content.
















    Your help will be appreciated

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: copy again the array in the first empty cell

    Maybe:


    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Contributor
    Join Date
    05-30-2013
    Location
    Isreal
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: copy again the array in the first empty cell

    Thank you that worked

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: copy again the array in the first empty cell

    You're welcome and thanks for the rep!

+ 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. Need to find empty filled cells in a column and copy to the empty cell below
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-30-2014, 10:09 AM
  2. Replies: 4
    Last Post: 02-20-2012, 04:50 AM
  3. Fill array till first empty cell.
    By UncleDucc in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-05-2009, 09:56 AM
  4. Copy to the next available empty cell
    By ged18 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-24-2007, 02:47 PM
  5. Replies: 5
    Last Post: 11-29-2005, 10:55 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