align data in a cell from VB

A

Alex

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

Thanks,

Alex
 
B

Bob Phillips

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)
 
A

Alex

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)




.
Click to expand...
 
Top