find specific titles in a table

  • Thread starter Thread starter layla
  • Start date Start date
L

layla

Hi,
I am looking for a certain text in a particular spread sheet,what
function/code can I use and how can I store the position
Thanks
 
Hi,

why not give us a little more detail: is the text going to appear more than
once. Are you searching for a particular item of text or will there be many
items. Do you want its position in R1C1 notation, as an offset from a
specific location, in A1 style and with its value. And is the text imbedded
in a longer string?

suppose the range is B1:G100 and you are looking for the word Apple by
itself in one single cell, then you can use the following array formula:

=ADDRESS(MAX((B1:G100="Apple")*ROW(B1:G100)),MAX((B1:G100="Apple")*COLUMN(B1:G100)))

Array - to enter it you press Shift+Ctrl+Enter, not Enter
 
Thank you Shane,for your reply,however your code doesnot run.I am
trying to find the bug but since i am very new to VBA ,I have trouble
to undrestand things that that you put inside the brackets

Thanks!
 
Back
Top