|
|
#2
01-09-2023, 08:51 PM
|
||||
|
||||
I'm thinking you need to convert the word constants into their integer values
wdAlignTabCenter = 1 wdAlignTabRight = 2 wdTabLeaderSpaces = 0 Code:
'So try changing this line rng.ParagraphFormat.TabStops.Add Position:=InchesToPoints(3.25), Alignment:=wdAlignTabCenter, Leader:=wdTabLeaderSpaces 'to rng.ParagraphFormat.TabStops.Add Position:=InchesToPoints(3.25), Alignment:=1, Leader:=0
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
| Tags |
| excel 365, word 365 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Tabs in word like Excel | kdawgtx | Word | 1 | 01-16-2021 08:09 PM |
| Word Document Restricted to using Tabs to move to next place for input | swalsh96 | Word | 2 | 09-20-2016 04:41 AM |
| HELP: Unable to save word document | SteveJ | Word | 0 | 06-28-2013 04:06 AM |
| Unable to select anything in an MS Word Document | PaulT | Word | 0 | 08-08-2011 07:45 PM |
| Creating custom tabs for Word & Excel 2003 on a Windows 7 OS | Skarab | Office | 1 | 07-05-2010 09:23 AM |
Unable to add tab stops to Word document via Excel VBA
Windows 10 
Office 2016
Threaded Mode