VBA code to identify the cell number in a column which contains a specific text

[rshnkmr39]

In Column A if cell 36 has "2015 Stores" then i need a code to identify this cell number.

This can be dynamic and the text can be present in any cell.

Thanks in advance.

[Philb1]

This will do if it's in column A & 2015 Stores is in B1

Please Login or Register  to view this content.

[sktneer]

Try something like this...

Please Login or Register  to view this content.

You may change the FindValue in the red line if you are looking for some other text in col. A. The above code will give you the address of the cell in col. A which contains 2015 Stores in it.
Moreover if you are interested in knowing the row number, you may change the message box to this...

Please Login or Register  to view this content.

Does this help?

[Philb1]

It just dawned on me you asked for VBA code. I see sktneer has already given one solution
Here's another. It'll find it anywhere on worksheet 1

Please Login or Register  to view this content.