| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Condensing VBA code
Can the following code be reduced?
Application.Proper(Cells(cell.Row, "C").Value) & " " & Application.Proper(Cells(cell.Row, "B").Value) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Condensing Columns | New Users to Excel | |||
| Condensing data from 3D to 2D | Excel Worksheet Functions | |||
| Condensing Formula | Excel Discussion (Misc queries) | |||
| Condensing my worksheet | Excel Worksheet Functions | |||
| Condensing lists | Excel Worksheet Functions | |||
Linear Mode
