PDA

View Full Version : My Macro sits and spins



Larbec
11-22-2015, 04:24 PM
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:


14822


When I go to debug, I get this:

14823

goes to debug and says this:

Can someone help me fix this?

Thank you

nilem
11-22-2015, 11:11 PM
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
11-23-2015, 01:48 AM
Testing more efficiently:


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

Larbec
11-23-2015, 05:35 AM
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
11-23-2015, 05:38 AM
@snb,

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

snb
11-23-2015, 05:47 AM
Only to replace



If isempty(range("Q5") then

and all the code between this If .... End if

End If