matching/finding text in 2 cells in worksheet

[Rasberry]

I want to find the text in a worksheet that resides in two cells (it is a column heading split into 2 cells). What code should I use to find the text string split into 2 cells? Any insight would be helpful! Thanks, Rasberry

 

[kkknie]

If you mean find as in using the find function it might look something like:

=FIND("ab", D15&E15)

Where the & concatanates (joins) the two strings.

If you mean something else, I'm sure concatanation is part of the answer.

Hope this helps,

K

 

[Rasberry]

I don't understand how that would work. I need to find the words "Rtn on Equity" in a spreadsheet, and "Rtn on" is in one cell, and "Equity" is in the cell below it.

 

[kkknie]

How are you searching? Are you using the Edit-Find menu function (ctrl-F)?

K

 

[Rasberry]

Thanks for responding. I am actually writing VBA code. I am trying to write code that searches the spreadsheet for the two consecutive cells and then it will perform another task after it finds those contiguous cells.

 

[kkknie]

If the cells are in the same row, this might work (untested):

'
' -Code assumes columns A and B are the headings
'
Sub FindEm()

dim i as long
dim iFound as long
dim sTemp as string

for i = 1 to 1000 'Your first row to your last row
   sTemp = Range("A" & i).value & " " & Range("B" & i).value
   if sTemp = "Rtn on Equity" Then
      iFound = i
      Exit For
   end if
next

'Continue on from here with i as the row number with the found heading

End Sub

This could also be converted into a function and called from a main subroutine.

K

 

[Rasberry]

Thanks! I haven't got it to work, yet. But it is something to start with. I'm working on getting the coding that will cycle through a range rather than just two columns. Basically the spreadsheet. But this is very helpful!