TigerVQ #3 Loops and Conditional Statements

This video deals with sophisticated loop control in Excel VBA. Specifically, how can we control a loop so that it only runs if we want it to run? In the example in the video, we look at creating reports for employees. But, if a report already exists, we want Excel VBA to ignore the loop and move onto the next employee. We look at how to combine loops and conditional statements to achieve the desired effect. The file builds on an example from one of our Excel VBA for beginners series that you can find here: https://youtu.be/Y-8pP_GWnao Download the file used in the series here: https://tinyurl.com/ldmdkly In the TigerVQ series, Chris deals with viewer questions in the comments on the channel. Why not leave a question for Chris in the comments? Link to TigerVQ playlist: https://tinyurl.com/lum5py7 Get in touch with Tiger using the platforms below! For regular spreadsheet hints and tips and more on the #ExcelRevolution: https://www.facebook.com/TigerSpreadsheetSolutions https://twitter.com/TigSpreadsheets http://tigerspreadsheetsolutions.co.uk