Avoid "Selecting" sheet in a For Next loop

Hi,

I'd like to avoid screen flashing in my macro so I set sheets that are created by the subroutine to be hidden. Is there a way the .Select line (bolded below) can be re-written to avoid having the sheet be selected?

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional.)



But, to be going on with, try ...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I don't know why you are using a loop to do this.

Use the Macro recorder to record you entering a formula in F1 to return the correct value. Paste that formula instead of ?????????????? below

Please Login or Register  to view this content.

If you want to use the loop, you need to look at the code in detail. Notice With ... End With and also the dots ( . ) in front of Range

This will fail:

Please Login or Register  to view this content.

because you can't select a cell on a hidden sheet.