ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   add right aligned tab with dot leader to word doc from excel (https://www.excelbanter.com/excel-programming/276720-add-right-aligned-tab-dot-leader-word-doc-excel.html)

DL[_3_]

add right aligned tab with dot leader to word doc from excel
 
This works in word 2002

Sub Add_Tab()
Selection.ParagraphFormat.TabStops.Add _
Position:=InchesToPoints(5.33), _
Alignment:=wdAlignTabRight, Leader:=wdTabLeaderDots
End Sub

I want to amend it to one line of code in a biggger macro in Excel 2002

Thanks,
Tegger





All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com