ExcelBanter - align data in a cell from VB

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

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

- - align data in a cell from VB (https://www.excelbanter.com/excel-programming/288839-align-data-cell-vbulletin.html)

Alex[_13_]

align data in a cell from VB

Please, advise how to align data in a cell to right (or
left) by using VB.

Thanks,

Alex

Bob Phillips[_6_]

align data in a cell from VB

ActiveCell.HorizontalAlignment = xlHAlignLeft 'xlHAlignRight,
xlHAlignCenter

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Alex" wrote in message
...
Please, advise how to align data in a cell to right (or
left) by using VB.

Thanks,

Alex

Alex[_13_]

align data in a cell from VB

Thanks a lot.

Alex
-----Original Message-----
ActiveCell.HorizontalAlignment =
xlHAlignLeft 'xlHAlignRight,
xlHAlignCenter

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Alex" wrote in
message
...
Please, advise how to align data in a cell to right (or
left) by using VB.

Thanks,

Alex

.

All times are GMT +1. The time now is 07:47 PM.