+ Reply to Thread
Results 1 to 3 of 3

Excel VBA code to copy a Range and paste it within a cell

  1. #1
    Registered User
    Join Date
    04-28-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    81

    Excel VBA code to copy a Range and paste it within a cell

    Hi,

    I have a few numbers in the range A1:A10
    125465
    876562
    684653
    313647
    251684
    322151
    351654
    321654
    846841
    515421

    I need to copy this range and paste all of it in cell B1,
    it must look like how it is displayed above but within cell B1


    Thank you so much in advance

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Excel VBA code to copy a Range and paste it within a cell

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,496

    Re: Excel VBA code to copy a Range and paste it within a cell

    If you get little squares at the end of each value, change the vbCrLf to Chr(10)

    Following works also but is not near as neat as Sixthsense 's code

    Change the cell references as required
    This assumes your values are in Column B starting at B1 and you want the result in Cell G1

    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. VBA code to copy cell formats and paste using offset for Rows/Range
    By spenlinhauer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2014, 07:45 PM
  2. VBA Code to copy cell range and paste to certain sheet
    By goguneon in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-03-2013, 08:35 AM
  3. VBA code to copy and paste range based on separate cell value
    By Mhofu in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-01-2012, 03:03 PM
  4. Vba code to copy and paste second visible cell to other worksheet range then the next
    By Justin25150 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2012, 09:03 AM
  5. Excel VBA Cell copy / paste Code request
    By RxMiller in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-18-2011, 10:27 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