ExcelBanter - Condensing VBA code

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Condensing VBA code (https://www.excelbanter.com/excel-discussion-misc-queries/242103-condensing-vba-code.html)

Brad

Condensing VBA code

Can the following code be reduced?

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

Bernie Deitrick

Condensing VBA code

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

--
HTH,
Bernie
MS Excel MVP

"Brad" wrote in message
...
Can the following code be reduced?

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

Brad

Condensing VBA code

Thank you

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

"Bernie Deitrick" wrote:

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

--
HTH,
Bernie
MS Excel MVP

"Brad" wrote in message
...
Can the following code be reduced?

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

Bernie Deitrick

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

All times are GMT +1. The time now is 06:54 AM.