View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Generating spaces in code

How do you insert spaces into a Debug.Print stmt via code. That is, I can
manualy put spaces into a text string by manually using the space bar (See
Below - 6 spaces). How would I do this via code? Do I have to use a Loop
with a space character?

Debug.Print "Hello " & TextVariable & " :"

Thanks
EM