Forum Discussion

Tom_Griffith's avatar
Tom_Griffith
Copper Contributor
May 16, 2023

VBA - Range to include numbered lists

Hello. If you have a minute, I'm extracting text from a range within MS Word...for example...   targetRange.Start=200 targetRange.End=500   This returns all the text (targetRange.Text) but since...
Doug_Robbins_Word_MVP's avatar
Doug_Robbins_Word_MVP
MVP
May 18, 2023

Tom_Griffith Use

 

With ActiveDocument
    .UndoClear
    .ConvertNumbersToText
    Selection.Range.Text = Replace(Selection.Range.Text, vbTab, " ")
    'do what you want to
    .Undo (3) 'may need to replace 3 to allow for other changes that you make
End With
Tom_Griffith's avatar
Tom_Griffith
Copper Contributor
Jun 14, 2023
ok, thanks so much for your help, that's what I did.

Resources