Exploring formating a string

SpaceFrog
09-09-2003, 02:39 AM
Dim mypatern$
Dim myarray As Variant
mypatern = String(n, "#") & "|"
theformat = ""
For i = 1 To Len(mystring) / n
theformat = theformat & mypatern
Next
mystring = Format(mystring, theformat)
MsgBox Format(mystring, theformat)
myarray = Split(mystring, "|")[VB]


why does
[VB]format (mystring, "## ##") work

but not

myformat = "## ##"
format (mystring, myformat)

SpaceFrog
09-09-2003, 02:56 AM
Ok got it !!!

shouldn't use # but @ !!!

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum