Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying question
If memory serves me right, I seem to remember a command in the BASIC language
that allowed for x number of spaces, say SPC(x). "X" would be caculated taking the length of the longest line and adjusting it for each short line as it was displayed. Something like this was used to help line up lines that were displayed with each line being different in length. Is there a function or command that can do this in VBA? Thanks, Les |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying question
Dim MyString
' Returns a string with 10 spaces. MyString = Space(10) ' Insert 10 spaces between two strings. MyString = "Hello" & Space(10) & "World" "WLMPilot" wrote in message ... If memory serves me right, I seem to remember a command in the BASIC language that allowed for x number of spaces, say SPC(x). "X" would be caculated taking the length of the longest line and adjusting it for each short line as it was displayed. Something like this was used to help line up lines that were displayed with each line being different in length. Is there a function or command that can do this in VBA? Thanks, Les |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|