excel vba coding line numbers?

Question

excel vba coding line numbers?

Answer 1

I haven t seen any built-in way to show line numbers. though there are toolbars you can add to your editor e.g. codeliner.

Answer 2

complicated factor lookup onto bing and yahoo it might help

Answer 3

Yes



the code to dispay line number is row



example if are standing in some cell you can catch the row with the following code



variablename = activecell.row



the cell name will be



variablename = activecell.address (false, false)

Answer 4

There is no native method to display the line numbers of your code in the VBA Editor. However, there are several 3rd party plugins that can do it for you. One I've used is from MZTools, (http://www.mztools.com/v3/download.aspx).



IF you are planning on using the line numbers for GOTO statements, DON'T! (A simple label works better, and doesn't need to be updated.) If you want them for reference and ease of navigating the subroutines, the above addin works great.