Word and line numbering - SOLVED

Darren Bartrup

Well-known Member
Joined
Mar 13, 2006
Messages
1,295
Office Version
  1. 365
Platform
  1. Windows
Hi all,

I wasn't sure where to post this, but it's definately not an Excel question but may have a VBA answer.

I'm trying to write up the code used in my Excel spreadsheets - my boss wants an explanation of how it all works just in case I get run over by a bus on the way home and I'd also like to know how it all works when I'm asked to change it six months down the line.

So I'm now in the process of copying my code to Word documents with explanations on what each section of code does. I do include comments in my code, but this is a more encompassing document explaining how each procedure links up, why certain controls need tags, etc.

When I paste the code into the document I format it as Courier New 10pt (HTML Keyboard style), with the rest of the document written in Arial 12pt. When I add line numbering to the code sections (seperated by continuous section breaks) they appear as 12pt type and I can't figure out how to change them to 10pt.

The only way around this I can think of is to number each line by hand, which is just plain silly.

Does anyone know of a way to alter the formatting of automatic line numbers?????

Any help with this would save me alot of time and would be greatly appreciated.

EDIT: I really should look further sometimes. Line numbers are a font style called, surprisingly enough, Line Number. Just modify the font style and mission accomplished.
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,113,794
Messages
5,544,322
Members
410,603
Latest member
rseckler
Top