VBA Debug Tool

[JoeC1]

Hi All,

I am trying to identify exactly what an existing macro is doing. The macro was initially written using the record function. Is there a way you can run VBA and the actual excel sheet simultaneously so that when I perform the debug (F8) I can see what impact each line of code actually has on the excel sheet.

Thanks for your help.
Joe

 

[RoryA]

You can reduce the size of the VBA window so that you can see the sheet at the same time.

 

[JoeC1]

Thanks Rory.