How can I copy text from cells from one worksheet to another. I have one worksheet that I have formulas for separating out first and last name. I want to copy that result to another worksheet as text into another worksheet. I just need the resultant text copied.
TIA
Sheet2.Range("A1").Value = Sheet1.Range("A1").Value
Manually = Copy cells in one workbook, in another PasteSpecial >> Values.
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
Posting Permissions
Reply With Quote
