Thank you Dave & Bob,

I did actually look in VBA Help but in my naivety I look up STRING, it
never occurred to me to look up DIM (no puns please <g)

Regards,

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Dave Peterson" wrote in message
...
I'm not Harlan, but take a look at Dim in VBA's help.

Then look at the description for "type". It contains this line "...String
*
length (for fixed-length strings)..."

Then try something like:

Dim myString As String * 1
myString = "asdfasdf"
MsgBox myString



Sandy Mann wrote:

Harlan,

Dim i As Long, k As Long, c As String * 1

May I ask why you DIMmed c as String *1?

I always understood that doing maths on strings was meaningless as in
"Sandy" * 1

Regards

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk

--

Dave Peterson