Table Intersection
 

Is it possible (through VBA or other methods) to activate the cell in a table
where the column heading is Apple and the row heading is Orange?

Table Intersection
 

Formula version

=INDEX(A1:M10,MATCH("Apple",A1:M1,0),MATCH("Orange ",A1:A10,0))

--
HTH

Bob Phillips

"StephanieH" wrote in message
...
Is it possible (through VBA or other methods) to activate the cell in a
table
where the column heading is Apple and the row heading is Orange?

Table Intersection
 

And the VBA version

Dim myCol As Integer
Dim myRow As Long
myCol = Application.Match("Apple", Range("A1:M1"), 0)
myRow = Application.Match("Orange", Range("A1:A10"), 0)
Range("A1:M10").Cells(myRow, myCol).Select

HTH,
Bernie
MS Excel MVP


"Bob Phillips" wrote in message
...
Formula version

=INDEX(A1:M10,MATCH("Apple",A1:M1,0),MATCH("Orange ",A1:A10,0))

--
HTH

Bob Phillips

"StephanieH" wrote in message
...
Is it possible (through VBA or other methods) to activate the cell in a
table
where the column heading is Apple and the row heading is Orange?