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:
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:
I tried a more simplified approach below and this codes works fine:
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?
Bookmarks