Screen location on Form Button activate?

[Brian F]

Excel 2010. I have a chart which responds to changing data in a table. When I click the form button that activates the vba routine that causes the data in the table to change the screen jumps to where ever it pleases (obscuring part of the chart). Is there some instructions I can insert in the routine that tells the screen to look at A215:BA261 or "Chart 1"?

Any help would be greatly appreciated.

 

[VoG]

Try

Application.Goto Range("A215"), True