Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding won't work???
Hello Everyone,
I loaded up a few variables from some cells in a sheet. BAdult and BChild. They contain numbers. But, when I put in this code to crosscheck that they don't exceed a value of 12. It is not working because instead of adding them, it puts them together. If BAdult + BChild 20 Then MsgBox "Max people in Business Class is 12!", vbInformation, "Compartment Error": BAdult.SetFocus: Exit Sub The values of BAdult is 6 and BChild is 8, it is bringing up the MsgBox because it is saying the value is 68, instead of 14?? How can I add these two variables instead of concanting them?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding time in a work schedule | Excel Worksheet Functions | |||
Adding new work sheet to end of workbook | Excel Discussion (Misc queries) | |||
adding cells in different work sheets | Excel Discussion (Misc queries) | |||
Adding Work Days only in a function? | Excel Worksheet Functions | |||
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions |