Speed Up For Each Cell Code

  • The code below changes the sign of certain cells based on the value of what is in the cell in the "B" column for the row. The code seems to work fine, but takes a long time to run. I have about 3000 rows with 12 cells in each row.


    Any suggestions to speed this up would be helpful.


    Thanks


  • Re: Speed Up For Each Cell Code


    While there may be other issues, I start with this type of method:

  • Re: Speed Up For Each Cell Code


    Why select?

  • Re: Speed Up For Each Cell Code


    Quote from royUK

    Why select?


    Why Loop?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!