Heres the Scenario:

In Excel:

Cells(1,1) = "Variable1"
Cells(1,2) = "+"
Cells(1,3) = "Variable2"

In VBA
Dim Variable1 as integer, Variable2 as integer
Variable1=1
Varable2=1
Test = Cells(1,1) & Cells(1,2) & Cells(1,3)

Obviously this will not work
But the Idea I want to convey is that is it possible to have this statement return a value of 2

Let me know if you need me to explain further.

The only other thing i can think of is using a Len Statement and a Select Case Statement to pick out which variable or sign is chosen.

Issue Resolved ... Len Statements and Select Cases work perfectly