The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Macros are a great time saver

Back to all questions

Macros are a great time saver

9 months ago
Vote Up Vote Down
0
Votes
2
Answer

I want to know if after recording with macros if I can still view the steps

2 Answers

365 Team 9 months ago
Vote Up Vote Down
0
Votes

Hi Madu,
To do that, you’ll need to read the associated VBA code.
We haven’t prepared a course on VBA, but will do that in the next few months.
Best,
Ned

9 months ago
Vote Up Vote Down
0
Votes

if you want to view the steps of the code as it runs, press Alt+F8, select the macro and ‘Step into’ then press F8 to advance through each step, ideally you’ll want a two screen set up so that each time you press ‘F8’ you can see what action each step takes in the Excel document.

You must to answer this question.
JanuaryPromo
×
Complete Data Science Education
Get 50% OFF