ExcelBanter - Insert Tab Character

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Insert Tab Character (https://www.excelbanter.com/excel-programming/429327-insert-tab-character.html)

Nigel

Insert Tab Character

I am trying to insert a tab character into a msg line for an email being
generated in excel, the tab function does not work, can someone supply the
format I would need to use in the following code

..appendtext "GLOBALDL Billings = " Tab(5) &
Round(Sheets("Variance").Range("C3"), 0) & " Bookings = " & Tab(5)
Round(Sheets("Variance").Range("d3"), 0)

the tab() function is only for printing

much appreciated

Gary''s Student

Insert Tab Character

Try vbTab or Chr(9).
--
Gary''s Student - gsnu200855

"Nigel" wrote:

I am trying to insert a tab character into a msg line for an email being
generated in excel, the tab function does not work, can someone supply the
format I would need to use in the following code

.appendtext "GLOBALDL Billings = " Tab(5) &
Round(Sheets("Variance").Range("C3"), 0) & " Bookings = " & Tab(5)
Round(Sheets("Variance").Range("d3"), 0)

the tab() function is only for printing

much appreciated

Nigel

Insert Tab Character

inserted it here
..appendtext "GLOBALDL Billings = " & chr(9)
Format(Round(Sheets("Variance").Range("C3"), 0), "#,###")

message is "Expected End of Statement"

"Gary''s Student" wrote:

Try vbTab or Chr(9).
--
Gary''s Student - gsnu200855

"Nigel" wrote:

I am trying to insert a tab character into a msg line for an email being
generated in excel, the tab function does not work, can someone supply the
format I would need to use in the following code

.appendtext "GLOBALDL Billings = " Tab(5) &
Round(Sheets("Variance").Range("C3"), 0) & " Bookings = " & Tab(5)
Round(Sheets("Variance").Range("d3"), 0)

the tab() function is only for printing

much appreciated

Jacob Skaria

Insert Tab Character

Try vbTab

String(5,vbtab)

If this post helps click Yes
---------------
Jacob Skaria

"Nigel" wrote:

inserted it here
.appendtext "GLOBALDL Billings = " & chr(9)
Format(Round(Sheets("Variance").Range("C3"), 0), "#,###")

message is "Expected End of Statement"

"Gary''s Student" wrote:

Try vbTab or Chr(9).
--
Gary''s Student - gsnu200855

"Nigel" wrote:

I am trying to insert a tab character into a msg line for an email being
generated in excel, the tab function does not work, can someone supply the
format I would need to use in the following code

.appendtext "GLOBALDL Billings = " Tab(5) &
Round(Sheets("Variance").Range("C3"), 0) & " Bookings = " & Tab(5)
Round(Sheets("Variance").Range("d3"), 0)

the tab() function is only for printing

much appreciated

Rick Rothstein

Insert Tab Character

Was the Format function call meant to be on the same line as your
..appendtext line? If so, then you are missing the & symbol in order to
concatenate it to the other text. If not, then the Format function has to be
used in some way (assigned to a variable, tested in an If..Then statement,
etc.)... you just have it sitting there.

--
Rick (MVP - Excel)

"Nigel" wrote in message
...
inserted it here
.appendtext "GLOBALDL Billings = " & chr(9)
Format(Round(Sheets("Variance").Range("C3"), 0), "#,###")

message is "Expected End of Statement"

"Gary''s Student" wrote:

Try vbTab or Chr(9).
--
Gary''s Student - gsnu200855

"Nigel" wrote:

I am trying to insert a tab character into a msg line for an email
being
generated in excel, the tab function does not work, can someone supply
the
format I would need to use in the following code

.appendtext "GLOBALDL Billings = " Tab(5) &
Round(Sheets("Variance").Range("C3"), 0) & " Bookings = " & Tab(5)
Round(Sheets("Variance").Range("d3"), 0)

the tab() function is only for printing

much appreciated

Rick Rothstein

Insert Tab Character

Nigel

Insert Tab Character

..appendtext "GLOBALDL Billings = " String(5,vbtab) &
Format(Round(Sheets("Variance").Range("C3"), 0)

Expected end of Statement error

"Jacob Skaria" wrote:

Try vbTab

String(5,vbtab)

If this post helps click Yes
---------------
Jacob Skaria

"Nigel" wrote:

inserted it here
.appendtext "GLOBALDL Billings = " & chr(9)
Format(Round(Sheets("Variance").Range("C3"), 0), "#,###")

message is "Expected End of Statement"

"Gary''s Student" wrote:

Try vbTab or Chr(9).
--
Gary''s Student - gsnu200855

"Nigel" wrote:

I am trying to insert a tab character into a msg line for an email being
generated in excel, the tab function does not work, can someone supply the
format I would need to use in the following code

.appendtext "GLOBALDL Billings = " Tab(5) &
Round(Sheets("Variance").Range("C3"), 0) & " Bookings = " & Tab(5)
Round(Sheets("Variance").Range("d3"), 0)

the tab() function is only for printing

much appreciated

Nigel

Insert Tab Character

All times are GMT +1. The time now is 12:23 PM.