Reading only values for macro

[stanysurfer]

I have a small problem, I have a macro that calculates a table of values by selecting from a range of values, namely x and y coordinates in A and B columns. It works fantastic if there are just the values there and nothing below the last point, the working macro can be seen in the attachment Project_JHunt...
Now if you look at Project_JHunt_2 the macro doesnt work as there are breaks between the values and below the last point the cells have "=Drilling!S25" etc. and the macro wont work with these in there.
So I ask, please, does anyone know a way to display the values from the "Drilling" worksheet under "Only points inside" to the "Block Block" worksheet so that my macro will work...have spent hours trying to work it out and I just cant do it.
Any help or guidance at all will be greatly appreciated.
Thank you!

[pike]

Hi stanysurfer,
Not that simple, It will require Sensibility tests. You will have to find four known points out side the area ( Max and min of points ).
The test point to each the four known points out side will make four lines.
Sensibility tests - if any of the four test lines intersect any of the lines that form the shape a total of four times ;Its in .

[stanysurfer]

Hi stanysurfer,
Not that simple, It will require Sensibility tests. You will have to find four known points out side the area ( Max and min of points ).
The test point to each the four known points out side will make four lines.
Sensibility tests - if any of the four test lines intersect any of the lines that form the shape a total of four times ;Its in .

Pike,
I can calculate all the points which are inside and outside of the area, I just need the macro to read those values, thats all. Is there a way to write into the macro to look up the values in the required cells that only have numbers in them...Thats all I really need..Thought it would just be a simple step i missed or something??
Cheers

[pike]

yes you have missed that its not that simple

[pike]

should say ,it can be done excel can compile all the calx its a complex question

[antoka05]

See attached file, maybe I did not understand the problem but I changed the macro 'CalcGammaDistances', and now it seems that works... I hope it's what you need.

Regards,
Antonio

[pike]

appoligise stanysurfer did realise that you had already done all the hard work
well done antoka05

[stanysurfer]

See attached file, maybe I did not understand the problem but I changed the macro 'CalcGammaDistances', and now it seems that works... I hope it's what you need.

Regards,
Antonio

Mate your a legend, exactly what I needed, Thank you so much!!
And cheers Pike for your input also, you guys are great

[stanysurfer]

appoligise stanysurfer did realise that you had already done all the hard work
well done antoka05

No problem at all mate, all good now

[pike]

Okie dokie

wow.... lots of hard work; very impressive

[antoka05]

Thanks to both.

Regards,
Antonio