View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
John John is offline
external usenet poster
 
Posts: 48
Default 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