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