How to get the cell that contains a certain text?
-
Hi, I 'm developing (trying actually) a desktop application that works well only if the word "PERIOD" is located in the cell A14(inside an excel file). But instead of that, I'd like to make it work if the word "PERIOD" is found no matter what cell it is in, provided it is inside the column 'A'. That's the problem, I don't know how to search a certain word inside a column and get its cell(the 'row part' actually). In other words I'm looking for this code: "If a cell inside column A contains "PERIOD", get the number of row". Any ideas? Thanks in advance.
-
Hi, I 'm developing (trying actually) a desktop application that works well only if the word "PERIOD" is located in the cell A14(inside an excel file). But instead of that, I'd like to make it work if the word "PERIOD" is found no matter what cell it is in, provided it is inside the column 'A'. That's the problem, I don't know how to search a certain word inside a column and get its cell(the 'row part' actually). In other words I'm looking for this code: "If a cell inside column A contains "PERIOD", get the number of row". Any ideas? Thanks in advance.