Help with access Lists Gallery to Format all

Guessed · #8 04-12-2021, 04:42 PM

I haven't seen multi-range selections in code before and that looks like an interesting avenue to explore.

If you are looking for a 'magic' way to apply styles in PDF conversions, I would consider trying the Autoformat command which is as close to vba magic as I've seen.

Code:

  With Options
    .AutoFormatPreserveStyles = False
    .AutoFormatApplyHeadings = True
    .AutoFormatApplyLists = True
    .AutoFormatApplyBulletedLists = True
    .AutoFormatApplyOtherParas = True
    .AutoFormatReplaceHyperlinks = True
    .AutoFormatReplaceQuotes = False
    .AutoFormatReplaceSymbols = False
    .AutoFormatReplaceOrdinals = False
    .AutoFormatReplaceFractions = False
    .AutoFormatReplacePlainTextEmphasis = False
    .AutoFormatPlainTextWordMail = True
    .LabelSmartTags = False
  End With
  Selection.Range.AutoFormat

If that doesn't work, post a sample document so I can see what you are actually looking at.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing two lists and extracting values missing from both lists	Dave T	Excel Programming	4	11-01-2018 11:51 PM
Creating global contact lists (distribution lists) Outlook 2011 Mac	pengyou	Outlook	0	09-10-2016 02:18 PM
I want to create a lists within lists (nested merges)	AndyS	Mail Merge	10	12-11-2015 03:05 PM
Add command (not gallery) to quick access toolbar	MarkPhil	Word	3	02-16-2014 06:10 AM
Project gallery	slidon	Word	0	04-29-2013 07:22 AM