Excel VBA Command - remove blanks after being copy/paste or copy/paste content from Textbox

[sammuelsama]

Hi Guys,


I create a template with some text on it that I can copy/paste to other apps with a copy button, really basic, selecting, copy to copyboard and pasting it where you want by doing a Ctrl+V but it's creating a lot of space or blanks between the text.

I still want to be able to add some modification to the selected text then I cannot put a limitation on characters.

I was thinking also on being able to copy content from a textbox but I cannot make it work...

Any ideas?

Thank you,
Sammuelsama

 

[sammuelsama]

This is my code;

Sub COPY4_Click()
'
' COPY4_Click Macro
'
Range("N44:S54").Copy
Application.Wait (Now + TimeValue("0:00:15"))
Application.CutCopyMode = False
'
End Sub

This code is simply copying a text contained in a cell range and I could verify there's no additional space or blanks in between.

Any idea?

TY,
Sammuelsama