View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scrabtree scrabtree is offline
external usenet poster
 
Posts: 2
Default Intersect Formula VBA Help

I need help with a VBA Intersect Formula. I have
locations identified going across the top of my
spreadsheet and then locations identified going down the
side of my spreadsheet. At the appropriate row/column
intersect cell the distance between the two locations is
identified.

I am going to have a userform pop-up and the staff can,
using a combo box, select the to and from location. I
need a formula that will look accross for the from
location and down the side for the to location and then
give me the intersect value????

SDC