View Single Post
 
Old 09-30-2024, 08:42 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 Format manual numbering so auto numbering code can run

Hi Greg, on the whole the code works as it should and I'm really grateful for your time - the only issue is that where there is a period followed by a space (see 1.2 and 1.3.1 in the first image), the code is adding an additional period but is removing the space (see second image).

Before code is run
Manual numbering should be separated by periods and no spaces inbetween.
Before.JPG

After the code has run
Where there is a period followed by a space (see 1.2 and 1.3.1 in first image), the code adds an additional period but does remove the space.
After.JPG

This is what the text should look like when the code has run, no double periods.
What it should look like.jpg


Quote:
Originally Posted by Shelley Lou View Post
Hi Greg, I have updated a previous post with before, after and what it should do/end result - it looks like its still the double period issue.
Reply With Quote