ExcelBanter - Cell format as "Text"

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

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

- - Cell format as "Text" (https://www.excelbanter.com/excel-programming/377955-cell-format-text.html)

EradicusMax

Cell format as "Text"

I don't working with the excel object model that much, so...
What is the property that should be set to make a cell of type "Text"
instead of "General", etc.

..NumberFormat="Text"; throws an error.

Gary''s Student

Cell format as "Text"

Selection.NumberFormat = "@"
--
Gary's Student

"EradicusMax" wrote:

I don't working with the excel object model that much, so...
What is the property that should be set to make a cell of type "Text"
instead of "General", etc.

..NumberFormat="Text"; throws an error.

EradicusMax

Cell format as "Text"

Thanks

"Gary''s Student" wrote in message
...
Selection.NumberFormat = "@"
--
Gary's Student

"EradicusMax" wrote:

I don't working with the excel object model that much, so...
What is the property that should be set to make a cell of type "Text"
instead of "General", etc.

..NumberFormat="Text"; throws an error.

All times are GMT +1. The time now is 10:03 AM.