Setting focus on workbook when code is Running

[jrean042]

Full disclosure, I posted this code here earlier today, but I received an answer that resolved my issue.
In this question, I have an odd issue. If I step through the code, it works as expected, but if I run the whole script, it does not produce the desired result. And I strongly believe it is because of the way I am referring to workbooks.

I have blocked off the part of the code that I need help with. And by help I need:

1. (If thee is one) A more efficient way of accomplishing what I am trying to do with the code. Mainly loop through a range and convert formulas to values (which works fine) and delete hidden rows. I'm thinking this can be done with one loop, but I have not been able to figure it out.
2. Fix what is causing the issue of the code behaving unexpectedly.

Everything within the "'####################" is supposed to be done in the newly created workbook. However after the file saves and closes and I reopen, it seems that some parts of the code did not run? I am honestly at a loss for what I am doing wrong and I am looking for someone with a bit more knowledge to guide me in the right direction.

Please Login or Register  to view this content.

[dangelor]

Using With statements might help...
https://docs.microsoft.com/en-us/dot...with-statement

Please Login or Register  to view this content.

[jrean042]

This is excellent!
Thank you very much for your time.
It was the syntax of naming the activeworkbook and then explicitly defining it that I was having trouble with.
I learned something new here. Thank you again

[dangelor]

Glad it helps!