ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Issue in Cell Value Alignment (https://www.excelbanter.com/excel-programming/311986-issue-cell-value-alignment.html)

Venkatachalam

Issue in Cell Value Alignment
 
Hi,
I am exporting data to each cell through an OLE function. I am using
WIN2K Prof OS and Office 2K.

When I export data to each cell, values are right aligned. All the cells
are right aligned, but some cells are not exactly right aligned. for Eg.

|----------|
| 123|
|----------|
| 123 | - Though right aligned, not properly... Why?
|----------|

Can any one explain me the cause and solution. If I set "WrapText" true...
then it works fine.

Any help appreciated.

Thanks

With Regards
Venkay

No Name

Issue in Cell Value Alignment
 
hi,
this can occur when the format of the cells are different.
may sure all of the cell have the same formatting.

-----Original Message-----
Hi,
I am exporting data to each cell through an OLE

function. I am using
WIN2K Prof OS and Office 2K.

When I export data to each cell, values are right

aligned. All the cells
are right aligned, but some cells are not exactly right

aligned. for Eg.

|----------|
| 123|
|----------|
| 123 | - Though right aligned, not properly...

Why?
|----------|

Can any one explain me the cause and solution. If I

set "WrapText" true...
then it works fine.

Any help appreciated.

Thanks

With Regards
Venkay
.



All times are GMT +1. The time now is 11:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com