Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
List File Properties - Author | Excel Worksheet Functions | |||
Browse File for Mac | Excel Discussion (Misc queries) | |||
VBA reseting variables | Excel Discussion (Misc queries) | |||
Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |