Intersect Formula VBA Help

  • Thread starter Thread starter scrabtree
  • Start date Start date
S

scrabtree

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
 
In the worksheet you would do

=Offset(A1,Match(to,A1:A200,0),Match(from,A1:AC1))

You can use the same formulas in VBA

With Application
miles =
..Offset(Range("A1"),.Match(to,Range("A1:A200"),0),.Match(From,Range("A1:AC1"
),0))
End With

where from and to represent string variables containing locations that
match one of your column and row entries.
 
Back
Top