View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Patricia Shannon Patricia Shannon is offline
external usenet poster
 
Posts: 56
Default VBA line numbers

I was looking at the Word line numbers, and it justs prints line numbers.
That wouldn't help me find the corresponding line when I'm working in the VBA
editor. I could write something that would add a comment followed by a line
number to the end of each line, but it doesn't seem worth it right now,
because this job ends at the end of the month.

"Dave Peterson" wrote:

Maybe you can work around it...

If you copy your code to MSWord, you can do this within MSWord:
File|Page setup|Layout Tab|Line numbers button.

You may want to change to landscape and use a smaller font, too.

Patricia Shannon wrote:

This is a suggestion for Microsoft:

It should be possible to automatically number and re-number lines of VBA
code, to make it easier to match code with a listing.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/communities...el.programming


--

Dave Peterson