excel - How to Include Space in VBA Text file output -


how can include space part of output in vba?

i have code below:

celldata = "aaaaa" & space & "bbbbb" 

and want generate output below:

"aaaaa" "bbbbb" 

but using code above, able generate:

"aaaaa""bbbbb" 

well " " space so

?"aaaaa" & " " & "bbbbb" aaaaa bbbbb 

or if want quotes

?"""aaaaa""" & " " & """bbbbb"" "aaaaa" "bbbbb" 

which of course:

? """aaaaa"" ""bbbbb"" "aaaaa" "bbbbb" 

space if function name have not valid, could:

"aaaaa" & space$(1) & "bbbbb" 

for single space.


Comments

Popular posts from this blog

javascript - Clear button on addentry page doesn't work -

python - Error: Unresolved reference 'selenium' What is the reason? -

asp.net ajax - Jquery scroll to element just goes to top of page -