Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating spaces in code
"ExcelMonkey" wrote in message
... 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 & " :" If I understand what you're trying to do you can use the VBA Space function. Space(6) will give you six space characters. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating spaces in code
Thanks Rob.
EM "Rob Bovey" wrote: "ExcelMonkey" wrote in message ... 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 & " :" If I understand what you're trying to do you can use the VBA Space function. Space(6) will give you six space characters. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically generating a city name based on entered zip code | Excel Discussion (Misc queries) | |||
need help in my code on generating chart with dynamic range | Excel Programming | |||
Generating Code in Excel / Macro Recorder Manipulation | Excel Programming | |||
generating sheet with command button & code | Excel Programming | |||
help with VBA code re comparing cells and generating message with detailed info | Excel Programming |