View Single Post
 
Old 02-28-2024, 10:37 AM
vivka vivka is offline Windows 7 64bit Office 2016
Expert
 
Join Date: Jul 2023
Posts: 293
vivka is on a distinguished road
Default

Shelley Lou, If I correctly understand your aims, I'd use characters, not words because of the MS Office's unusual idea of a word.

Since I have no opportunity to test the following, try experimenting with the code:

Code:
If sLastWord = "]" Then msgbox sLastWord.range.characters.first.previous
Reply With Quote