refer to cell using the value in Row 1 and column A

G

Guest

I need to locate a cell that is the intersection of cells in row 1 and column
A by matching text . For example find "Allowed" in Row 1 and "WaterTemp" in
Column A and give me the cell address at the intersection. I tried nesting
two match functions inside index function but it hiccupped.
 
G

Guest

Tom,
Thanks for the quick response
Your response is what I tried in VBA but I get "Can't set index
property..."error. I am grabbing a value from Access and need to insert it
into the desired cell. I did use a clunky routine to find the text and grab
the column from row 1 and the row from column A to construct an address. It
works but seems inefficient.
 
T

Tom Ogilvy

set rw = Range("A1:A26).Find("WaterTemp")
set col = Range("A1:Z1).Find("Allowed")
cells(rw.row,col.col).Value = "Whatever"
 

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

Write to intersect of a row and column 7
how to find value on the cross of row and column 6
Column number of last column that returns value ignore formulas 8
Return the contents of a cell at the intersection of row and colum 1
For-Next by a row Counting consecutive Zero in the column 4
Create if partial match then copy and paste data from one cell to another 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
refer to another cell in the same row with the active cell 1

Top