Table Intersection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Next Largest Number Based on Criteria 3
Random selection of records based on specifc value 5
lookup 1
Counting and deleting rows 5
Create a small table from a large table by skipping empty columns 4
Macro to add numbers in a text string 5
Fill in Blanks 6
How to dynamically change the list in drop down list based on thevalue of another cell? 1

Back
Top