Plot coordinates using vba

hello friends,

Thanks to Andy I have this file which is working like a charm. because not all the users have excel abilities they messed up my file. do you have any idea what should I do to prevent it? One way is using a UserForm but it rqrs some code. I tried something but I can not figure out.
The scenario is: the user enter data for points and for the "red area" and the result should be in chart.
I have problems with the ranges, with the axes...because the range(s) is dynamic, I may have 2,3,4 or 12 route points and 4,5,6 or 12 red area points, anyway my script is awful!
I really appreciate your help.

anyone?...

Hi,
perhaps someone can help me...

posted here also
http://www.thecodecage.com/forumz/sh...post1055011411