How to Count Line Numbers in Excel VBA. ... may contain extended comments on each worker's performance. Excel controls the number of ... count the lines in cell E2, change the code to: ...

If you are unfamiliar with working with VBA, here is the short version of how to make use of this: Open your worksheet in Excel. ALT-F11 (opens the VBA coding window) ...