code that interacts with a specific cell

i have a code that i somehow pieced together

Please Login or Register  to view this content.

i would like to replace the "30" with whatever is in cell Z3.

so that i dont have to open the VBA window everytime i want to change refresh rate, i can simply enter in this cell.

TY in advance!

What are you trying to refresh? Power Query connections? If so, you don't need the on time method

You can use this up to a minimum of 1 minute

Please Login or Register  to view this content.

seems like this should work but it is not

NM... it works perfect! im just a big noob lol... TY all so much!