You could also use a UDF...
Add this to a new module in your workbook:
Then, in cell C69 type: =ADD(C68)![]()
Function Add(Rng As Range) As Variant Add = Evaluate(Application.Substitute(Rng, "/", "+")) End Function
- Moo
You could also use a UDF...
Add this to a new module in your workbook:
Then, in cell C69 type: =ADD(C68)![]()
Function Add(Rng As Range) As Variant Add = Evaluate(Application.Substitute(Rng, "/", "+")) End Function
- Moo
Last edited by Moo the Dog; 01-29-2013 at 01:41 PM. Reason: h/t to Andrew Poulsom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks