how do you execute single line of code?
 

i am troubleshooting some code i wrote, and it would be very helpful to
know the command for running the code line-by-line so i can identify my
error more quickly. thanks.


--
honestlylion
------------------------------------------------------------------------
honestlylion's Profile: http://www.excelforum.com/member.php...o&userid=31674
View this thread: http://www.excelforum.com/showthread...hreadid=516195

how do you execute single line of code?
 

"honestlylion"
wrote in message
news:honestlylion.23qoza_1140794400.9802@excelforu m-nospam.com...

i am troubleshooting some code i wrote, and it would be very helpful to
know the command for running the code line-by-line so i can identify my
error more quickly. thanks.

While in the code editor, click on Help, start the help system, and search
for the word "Step". That'll tell you how, assuming Excel uses the same
terminology as every other programming language on earth.

how do you execute single line of code?
 

Have a look at the Debug menu in the VBA window: it shows the
options and shortcuts, e.g. F8 to step through the code.
You can also make a line a Breakpoint (F9), which will make the
debugger stop when it reaches the line.


honestlylion wrote:
i am troubleshooting some code i wrote, and it would be very helpful to
know the command for running the code line-by-line so i can identify my
error more quickly. thanks.


--
honestlylion
------------------------------------------------------------------------
honestlylion's Profile: http://www.excelforum.com/member.php...o&userid=31674
View this thread: http://www.excelforum.com/showthread...hreadid=516195