Condensing VBA code

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

Can the following code be reduced?

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

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

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

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MACRO COLUMNS, SKIP ROWS 6
MACRO PASTE CELL to COLUMN, SKIP ROWS 1
SENDING EMAIL WITH PASS/FAIL RESULT 0
ComboBox Question 2
Seaching an excel sheet 1
VBA Email Cell Contents When Filled In 4
problem with macro 1
Conditional borders 3

Back
Top