Condensing VBA code

's Computer Specifications

Can the following code be reduced?

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

's Computer Specifications

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

--
HTH,
Bernie
MS Excel MVP

"Brad" <(E-Mail Removed)> wrote in message
news:8CBF53FE-8BE0-401C-80CD-(E-Mail Removed)...
> Can the following code be reduced?
>
> Application.Proper(Cells(cell.Row, "C").Value) & " " &
> Application.Proper(Cells(cell.Row, "B").Value)
>
>
>

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
> news:8CBF53FE-8BE0-401C-80CD-(E-Mail Removed)...
> > Can the following code be reduced?
> >
> > Application.Proper(Cells(cell.Row, "C").Value) & " " &
> > Application.Proper(Cells(cell.Row, "B").Value)
> >
> >
> >
>
>
>

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Condensing code	Brad	Microsoft Excel Programming	1	9th Dec 2008 05:27 PM
Condensing working code	Brad	Microsoft Excel Programming	3	20th Nov 2008 02:00 PM
Condensing Code	=?Utf-8?B?c3RldmU=?=	Microsoft Excel Programming	1	23rd Aug 2006 08:37 PM
Need help condensing with-end with code	excelnut1954	Microsoft Excel Programming	2	1st May 2006 03:49 PM
Trouble Condensing Code	Ikaabod	Microsoft Excel Programming	3	11th Apr 2006 09:53 PM