Ok here is the main sub. The code works fine unless the cells get stuck in #REF, hence why it works 9/10 times. The reason that is an issue is because I need the values to identify the last row. I need the last row to run some formatting code. I tried using wait and it just seemed to wait - not wait and let the data refresh. I have an optimization sub I run early on that has screenupdating = false. I tried setting it to true but that didn't help either. I can't really post the workbook as all the links are on a server and it is sensitive data. Let me know what you think.
Bookmarks