Condensing VBA code

B

Brad

Can the following code be reduced?

Application.Proper(Cells(cell.Row, "C").Value) & " " &
Application.Proper(Cells(cell.Row, "B").Value)
 
B

Bernie Deitrick

Application.Proper(Cells(cell.Row, "C").Value & " " & Cells(cell.Row, "B").Value)
 
B

Brad

Thank you

I didn't know if you could somehow have
Application.Proper(Cells(cell.row, "C"&" "&"B").Value
 
B

Bernie Deitrick

You're welcome.

But you cannot do what you describe - you need to process the multiple values separately...

HTH,
Bernie
MS Excel MVP
 
Top