LordSnow548
Banned user
- Joined
- Apr 29, 2020
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
Hello all,
I have a need to copy text from a set of merged cells using VBA by being able to click on a button, what i have thus far is:
Private Sub CommandButton2_Click()
'Copy Single cell
Range("E6:G28").Copy
End Sub
It works well, but its copying a lot of dead space and not just the text, so it copies the text and then several lines of just nothing at all, is there anything i can do to the above to only copy the visible text?
I have a need to copy text from a set of merged cells using VBA by being able to click on a button, what i have thus far is:
Private Sub CommandButton2_Click()
'Copy Single cell
Range("E6:G28").Copy
End Sub
It works well, but its copying a lot of dead space and not just the text, so it copies the text and then several lines of just nothing at all, is there anything i can do to the above to only copy the visible text?