Hi,
I am working on automating a report we prepare on a regular basis.
The one thing i want but not sure how to do is.... I want my macro to be paused in between after performing some actions for me to see if the values genereted/populated are alright or not, then once I am done i want my macro to continue it's remaining program from the point it was stoped.
example code :-
Sub Macro()
Performs commands
!
!
Paused here (for me to check the results till now)
!
!
then again performs the remaining commands
end sub
Please help!
Regards,
Premanshu.
I am working on automating a report we prepare on a regular basis.
The one thing i want but not sure how to do is.... I want my macro to be paused in between after performing some actions for me to see if the values genereted/populated are alright or not, then once I am done i want my macro to continue it's remaining program from the point it was stoped.
example code :-
Sub Macro()
Performs commands
!
!
Paused here (for me to check the results till now)
!
!
then again performs the remaining commands
end sub
Please help!
Regards,
Premanshu.