Thread: [Solved] VBA Run Time Error 91
View Single Post
 
Old 09-11-2024, 05:06 AM
Shelley Lou Shelley Lou is offline Windows 10 Office 2016
Expert
 
Join Date: Dec 2020
Posts: 259
Shelley Lou is on a distinguished road
Default VBA Run Time Error 91

Hello again Vivka, how strange that it works on your PC, I've just run your updated code but still getting the run time error 91 on this line

Code:
While rng.Characters.Last.Previous = "."
To further test I have selected just the text from 1 CABINET SUB-COMMITTEES down to 2.7.2. which worked but even though I had not select 3 Function of the Shareholders, the code still inserted a full stop after 3. I then selected the text from 3.1 to 3.12 but got the run time error. Any ideas?
Reply With Quote