? about the VBA code
 

Something like this ... ?


Code
-------------------
If ActiveSheet.Range("a1").Value < 0 Then
Range("C4").FormulaR1C1 = _
Else
Range("C4").FormulaR1C1 = _
End If

-------------------


--
Message posted from http://www.ExcelForum.com

? about the VBA code
 

no not really

i am looking for something like c++ were i make my column an int s
that i can change it and it will change the formula depending on what
store in that in

--
Message posted from http://www.ExcelForum.com

? about the VBA code
 

I suggest you try a c++ forum. We generally use VBA

--
Message posted from http://www.ExcelForum.com