Need a help to tidy up VBA code for auto scaling a chart.

Hey guys,

I need a bit of help with this code I've written.

My worksheet calculates the max value from a set of cells then autoscales the chart.

The problem is, it flickers because its constantly calculating on the fly.

Some how I need to have an 'If Then' in there somewhere to tell it to only calculate when the last cell value has been entered.

Also, I've probably got way too many "With" and "End With" in the code.

The minimum scale isn't actually required because its always 0, but I can just remove that line.

Any help or advice is greatly appreciated.

Below is the code.

Cheers.

Please Login or Register  to view this content.

I think I may have worked it out.

When I get time, I'll have another look and if its still not working, I'll post the file.

Thanks nobffinme

Thanks sixthsence,

I came up with a solution before I read your post.

I set that code up as a marco and just used the following:

Please Login or Register  to view this content.

B62 being the last cell that had a required a value.