My Macro sits and spins

[Larbec]

I have this same Macro working 100% in other books that I am using. The exception between these book is that the others utilize I2:O101 and this one I am wanting to use I2:N101. When I place a Game # in Q5 to do a reset back to a specific Game # the Macro sits and spins until I finally hit escape or sometimes have to X out of it and then it, i get a range error:


Range Failed.jpg


When I go to debug, I get this:

Debug.jpg

goes to debug and says this:

Can someone help me fix this?

Thank you

[nilem]

There are a lot of conditional formatting rules, which were formed due to the copy range.
Try removing extra CF and refrain from copying (insert only values).

[snb]

Testing more efficiently:

if ([Q5]-1)\50<>0 then exit sub

[Larbec]

I've actually removed all the CF except the Gray/green , Red/yellow number cells on another test sheet and it dies the same thing.

It's suppose to copy and paste to whichever Game number I place in Q5. So if all cells are full to row 2 Game 50 and I put 48 in Q5 it should copy or cut I2:N101 and paste the numbers row 4 leaving ? In rows 2 and 3. The numbers in row 99 and 100'drop off I hope this makes sense

[Larbec]

@snb,

are you suggesting I replace this code in place of another in mine?

[snb]

Only to replace

If isempty(range("Q5") then
 
   and all the code between this   If  .... End if

End If