Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting text in specific cell
Hi everyone.
I want to use VBA to create a table in Word and format specific cells so that the text in them is either Left, Right or Centred. I have tried using the Cells object but get nowhere. Anyone able to help? Thanks Tim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting text in specific cell
Hi Tim.
I want to use VBA to create a table in Word This is probably more appropriate to a Word NG, but turn on Word's macro recorder while you perform the operation manually. This will provide you with code which can be edited for generic application. format specific cells so that the text in them is either Left, Right or Centred. I have tried using the Cells object but get nowhere. If this question id Excel based, to left, right or centre align a cell try: Range("A1").HorizontalAlignment = xlLeft Range("A1").HorizontalAlignment = xlRight Range("A1").HorizontalAlignment = xlCenter If this is word related, return to the macro recorder for the requisite syntax. --- Regards, Norman "tim" wrote in message ... Hi everyone. I want to use VBA to create a table in Word and format specific cells so that the text in them is either Left, Right or Centred. I have tried using the Cells object but get nowhere. Anyone able to help? Thanks Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text specific using conditional formatting | Excel Discussion (Misc queries) | |||
formatting specific cell | New Users to Excel | |||
formatting text on chart for specific values | Charts and Charting in Excel | |||
Converting Text files to Excel sheets with specific formatting | Excel Programming | |||
conditional formatting on specific text in cells | Excel Discussion (Misc queries) |