Hi Margie,

Try this

For i = 1 to n
myString = myString & i
Next i

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"margie " wrote in message
...
I need some help with string functions. Let's say I have a set of
numbers from 1 to n. (1,2,3,4,...n). the user will input what the
value of n will be. the program will then create the string of numbers
from 1 to n. I've been playing around with the mid function but that
requires an initial defined string. Is there any way to create this
string of numbers without an initial defined string?

example:

user defines n=9

string = 123456789

thanks.


---
Message posted from http://www.ExcelForum.com/