View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
brya6347 brya6347 is offline
external usenet poster
 
Posts: 1
Default 10 X 10 grid and finding distances from multiple points...


here is what i need help with...

this is a small example of what i need to do...

10 X 10 grid (x-y axis 0-10)

on the grid are 4 points (for example (2,3)(3,4)(5,5)(7,5))

i need to determine the distance of each point to each grid mark..for
example each point on the grid (0,0)(0,1)....(10,10) i need to find the
distance that point is to the all 4 points that are user defined.

i am trying to write a routine in VBA that will do this

it has been awhile since i tinkered with VBA so any help would be
greatly appreciated


--
brya6347
------------------------------------------------------------------------
brya6347's Profile: http://www.excelforum.com/member.php...o&userid=20024
View this thread: http://www.excelforum.com/showthread...hreadid=346089