Macro execution help

Dan Wilson

Active Member
Joined
Feb 5, 2006
Messages
448
Office Version
  1. 365
Platform
  1. Windows
Good day. I am running Office 365 (updated) on Windows 10 Home. I have recently been given a Macro that works extremely well although I don't understand all of the coding. Is there a way that I can execute the Macro one line at a time and see the results of that line? Thank you for any help with this.
Dan Wilson...
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,372
Office Version
  1. 365
Platform
  1. Windows
It is hard to day, because we don't really know what the macro is doing or what the code looks like.
Note that you can go through a macro one line at a time by stepping into it and using the F8 key.
If you hover over any variables along the way, it will show you the value.

You can also put break points and message boxes in there to stop at certain points, and see what it has done.

Lastly, you can use the Immediate Window.
See: Use the Immediate window (VBA)
and 5 Ways to Use the VBA Immediate Window - Excel Campus
 
Solution

Dan Wilson

Active Member
Joined
Feb 5, 2006
Messages
448
Office Version
  1. 365
Platform
  1. Windows
It is hard to day, because we don't really know what the macro is doing or what the code looks like.
Note that you can go through a macro one line at a time by stepping into it and using the F8 key.
If you hover over any variables along the way, it will show you the value.

You can also put break points and message boxes in there to stop at certain points, and see what it has done.

Lastly, you can use the Immediate Window.
See: Use the Immediate window (VBA)
and 5 Ways to Use the VBA Immediate Window - Excel Campus


Good day Joe4. Thank you for responding. That is what I was looking for. I know about stepping into a Macro, but I did not know how to make it advance.
Dan Wilson...
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,372
Office Version
  1. 365
Platform
  1. Windows
You are welcome.
 

Forum statistics

Threads
1,136,863
Messages
5,678,205
Members
419,750
Latest member
crp

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top