Jumping screen problem.

[Sarkonis]

Hi Guys,

Been searching all over and not finding very little about this problem.

I have a spreadsheet I keep all my business data in, been using it quite a while. Suddenly it has developed a problem where each time I click on a different cell the screen jumps around and tries to center the new cell on my screen. Based on my research it has something to do with "snap to cell". I have no idea what this is, or where to find it.

How do I make this stop? It's driving me insane having to reset my horizontal/vertical position every time I enter a new cell!

Why did it suddenly start doing this?!

TIA!

 

[Sarkonis]

Did you try turning off Screen Updating...

Application.ScreenUpdating = False
    
    'Your Code
    
Application.ScreenUpdating = True

So simply yet so effective, I feel like an idiot for not realizing the cause sooner, but because it didn't affect it for months I never thought it was the problem.

Thank you so much igold!

 

[igold]

I was happy to help! Thanks for the feedback!