align data in a cell from VB

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

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

Thanks,

Alex
 
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)
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

alignment of SOME text in a textbox 10
BEST suggestion to keep formats? 10
Alignment 4
align autoshape with centre / right of excel cell 2
Accounting Format not aligned 1
How to align decimals in a Listbox 2
Cells(r, c) syntax and horizontal alignment 3
Conditional Formatting and Text Alignment 3

Back
Top