| Step through code and see what happens. F8 - Next statement CTRL Shift F8 - Skip out of procedure Stop Yellow highlight is a statement about to be executed Tracking Problems you find I have data from different dates but when opening a sheet I don't know what date the data is from. If you want to retain multiple versions then you could append the date to the sheet name. If you want to have just one sheet then load the date into a cell when the sheet is generated. Set a Breakpoint Stop Hacking I hack the Jira Yes/no dialog. It doesn't work but you don't give up Trial and error Research on Google. CTRL Shift F8 over a routine |