+ Reply to Thread
Results 1 to 1 of 1

Combine Values of Multiple Cells in a Range

  1. #1
    Forum Contributor PY_'s Avatar
    Join Date
    09-23-2008
    Location
    Houston
    MS-Off Ver
    Office 2016
    Posts
    289

    Question Combine Values of Multiple Cells in a Range

    This is a portion of my code that will take all the data on Sheet10 starting at Row10 down to the last used row and copy that data to another sheet. This code works fine:

    Please Login or Register  to view this content.


    The problem i am having is i get a run-time error 13 (Type mismatch) if i try to combine values of multiple cells. Here is how my failed attempt looks:
    Please Login or Register  to view this content.


    I tried a more simplified approach below and this codes works fine:
    Please Login or Register  to view this content.


    I am guessing i am typing the code incorrectly due to the range. Can someone point me in the right direction as to why it is failing?
    Last edited by PY_; 12-13-2011 at 08:56 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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