String variables
 

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

String variables
 

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

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

Regards

Trevor


"John" wrote in message
...
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

String variables
 

That fixed it. Thanks

John

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

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

Regards

Trevor


"John" wrote in message
...

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

String variables
 

You're welcome. Thanks for the feedback


"John" wrote in message
...
That fixed it. Thanks

John

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

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

Regards

Trevor


"John" wrote in message
...

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