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
James - 27 Jan 2008 22:36 GMT
Dim MyString
' Returns a string with 10 spaces.
MyString = Space(10)
' Insert 10 spaces between two strings.
MyString = "Hello" & Space(10) & "World"
> If memory serves me right, I seem to remember a command in the BASIC
> language
[quoted text clipped - 8 lines]
> Thanks,
> Les