View Single Post
 
Old 04-07-2025, 04:01 AM
RobinClay RobinClay is offline Windows 10 Office 2019
Novice
 
Join Date: Jan 2021
Posts: 9
RobinClay is on a distinguished road
Default Formatting dates only in Diary transcriptions

I am SO lucky to have a team transcribing - a month at a time - my grandmother's diaries, 1900-1977.
I send out the scans and a "blank" Word Doc with the dates formatted, so I can then just paste that month into a file for that year.
But my most prolific transcriber always sends it back as a plain .txt file.
So I format say
"Sun Jan 1 1965 Salisbury"
as Bold, size 14

Then I click on the "Format Painter" icon,
then move to
"Mon Jan 2 1967 Home"
and select that entire line.
Job done !

BUT . . I have to do that 365 (or more !) times for each year !

Would some kind soul please give me a VBA routine that would

Run through the entire file
Find every line that is empty, but is followed by a line that starts with "Mon ", "Tue ", etc
Then format that entire second line as Bold, size 14.

I can do that SORT of thing in Excel VNA, no sweat - but WORD VBA is a complete mystery !

Pretty please ?
Reply With Quote