align data in a cell from VB

Alex · Jan 22, 2004

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

Thanks,

Alex

Bob Phillips · Jan 22, 2004

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 · Jan 22, 2004

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)

.