Condensing VBA code
You're welcome.
But you cannot do what you describe - you need to process the multiple values separately...
HTH,
Bernie
MS Excel MVP
Thank you
I didn't know if you could somehow have
Application.Proper(Cells(cell.row, "C"&" "&"B").Value
|