String variables

  • Thread starter Thread starter John
  • Start date Start date
J

John

I dim Warning(100) as string

Then I do the following:

Warning(1) = Cells(1, 3) + " " + Cells(3, 3) + " " + "Assessments" + "=
" + Cells(2, 13) + "," + Cells(2, 16)


Cells (1,3) is a string
Cells(3,3) is a social security number
"Assessments" I mean the word Assessments
Cells(2,13) and Cells(2,16) are numbers


I want Warning(1) to = "Joe Blow 123-45-6789 Assessments 4,5"

I get a type mismatch.

This is old code from Power Basic.

Help and thanks

John
 
Try using "&" instead of "+" to concatenate the strings

Suspect it's trying to add up and finding data other than numbers

Regards

Trevor
 
That fixed it. Thanks

John

Trevor said:
Try using "&" instead of "+" to concatenate the strings

Suspect it's trying to add up and finding data other than numbers

Regards

Trevor
Click to expand...
 
Back
Top