Results 1 to 3 of 3

Copy values from one column to the end of values already contained in the cell of another

Threaded View

GavJ Copy values from one column... 10-18-2013, 12:56 AM
:) Sixthsense :) Re: Copy values from one... 10-18-2013, 01:05 AM
HaHoBe Re: Copy values from one... 10-18-2013, 01:19 AM
  1. #1
    Registered User
    Join Date
    08-31-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    38

    Copy values from one column to the end of values already contained in the cell of another

    Sub append()
        result = Range("C5")
        Range("i5") = Range("i5") & result
    End Sub
    So value in c5 is appended to the value in i5.
    How do I do this for the values in column "C" to columm "I"?
    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] Copy a column of mixed date values and increment all values by 1 day
    By Jonj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-23-2013, 04:05 AM
  2. [SOLVED] Loop-copy cell values from a row, and then copy them into a column
    By vukovicnikola in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2012, 06:03 AM
  3. Replies: 0
    Last Post: 09-06-2012, 04:06 AM
  4. Macro that will copy values in Column J and paste values to Column B in new sheet
    By Phixtit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2010, 04:56 PM
  5. writing formulas in VB - referring to the values contained in cell
    By Josie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2006, 02:40 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