Reading only values for macro

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!