MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Carriage Return within CONCATENATE function

  Asked By: Grant    Date: Jan 23    Category: MS Office    Views: 10311

I know it is a little bit outside the scope of the VBA group, but I cannot find
an answer for inserting a carriage return into a concantenate function. Any



6 Answers Found

Answer #1    Answered By: Muhammad Evans     Answered On: Jan 23

I've not worked with the Concatenate function, but I would try either
"vbCrLf" or "Chr (10) & Chr(13)"

Answer #2    Answered By: Kian Evans     Answered On: Jan 23

Use the character for carriage  return rather than a carriage return  itself.

It is either chr13) or char(13)

Answer #3    Answered By: Tomas Thompson     Answered On: Jan 23

Thanks for the advice. I found that "&CHAR(10)&" along with enabling "Wrap
Text" for the cell works.

Answer #4    Answered By: Madeeha Malik     Answered On: Jan 23

i had Started a project in Excel . i want to know the sintex example for all
command in VBA .
Ex. .list etc

Answer #5    Answered By: Aaminah Khan     Answered On: Jan 23

The best resource for syntax is to use the help files in the editor. When you
are in the editor type list and then press F1. You will get an option of
looking at the information about Excel list or Office List. Choose the excel
one. This will give you the information about using list in your code.

Answer #6    Answered By: Anne Powell     Answered On: Jan 23

If you want a complete list of all the objects, methods and properties you can
use in VBA, go to help, Microsoft Excel Visual Basic Reference, Microsoft
Excel Object Model.

Under Objects all the objects are listed
Under Methods all the methods are listed
Under Properties all the properties are listed.

There is also a lot of information under Programming Concepts.

I think this resource would answer  most of your questions, but please feel
free to post back if there is anything you still have problems with.

Didn't find what you were looking for? Find more on Carriage Return within CONCATENATE function Or get search suggestion and latest updates.