Posted to microsoft.public.excel.programming

DL[_3_]

external usenet poster

Posts: 13

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I insert a dot leader in Excel?	Karen	Excel Discussion (Misc queries)	3	April 3rd 23 12:10 PM
Excel print not aligned on 2nd and subsequent pages of report	Neil McKeown	Excel Discussion (Misc queries)	0	January 6th 11 03:50 PM
how can i add numbers from non-aligned rows and cells in excel?	militia	Excel Discussion (Misc queries)	1	January 22nd 09 11:05 PM
Leader Board	Ben	Excel Discussion (Misc queries)	5	April 9th 07 11:56 PM
Leader Board 2	Ben	Excel Discussion (Misc queries)	1	April 9th 07 04:46 AM

All times are GMT +1. The time now is 04:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us