Hi,

I've got a two part question.  First, how do I paste with destination formatting?  Is this possible?  Also, how do I set the range to start under the header and only select cells that have text in them for pasting?

Here is where I'm at

Sheets("Sample_Data").Range("A2:A95").Copy Sheets("Testing_Data").Range("G2")

Thanks for the help!

Hi A_Shannon,

For your question 1, you wonder to paste the content with the destination formatting. If the content without formulas. You can only paste the content as VALUE, so the destination formatting wont change after pasting. If the content contain formulas, you can paste the content as FORMULAS. As shown in the following figure.

And for your question2, I dont understand the meaning of have text in them. My understanding is you have a range of data (e.g. TEXT123; TEXT; T123EXT; TE123XT...), and you only need TEXT; TEXT; TEXT; TEXT without numbers after pasting them. If my understanding is correct, there is no directly way to get the result. But you can use a workaround to help you. Please refer to the following steps and figures.

1. Copy the TEXT from Excel to Word.
2. Use Ctrl+H - enter [0-9] in Find what - and select MORE option - check Use wildcards - Replace All
3. Copy the TEXT replaced from Word back to Excel.

If my understanding is incorrect, please provide a sample about your issue. Or you could be a bit more precise explain your problem so that we can get more accurate solutions to this problem. Im glad help and follow up your reply

Regards,

George Zhao
TechNet Community Support