UDF Match functions that returns ROW and COLUMN position

[CrispinB]

Hi. Sorry I am new to this. Can somebody shows me how to create a UDF that is almost like the Match Function but instead will return the Intersection where the match string was found. (in Column and Rows).

Example. I want to see which cell contains the word "Start Here". I need to do this in Macro coding.

Thank you very much in advance.

Sincerely

CrispinB

[JBeaucaire]

You can use the "FIND" method to get the exact cell that has that text in it. Then you can use that range address anyway you wish.

Please Login or Register  to view this content.

[CrispinB]

Jerry, Wow !!! Thank you very much, This is exactly what i need. you're awesome man!! thanks again.

[CrispinB]

Jerry, How about if "Start Here" is just part of a string, is that still possible?

[CrispinB]

Jerry, Nevermind, I figured it out. all i need to do is replace "Lookat:=XLWhole" with "Lookat:=XLPart", and it works. thanks again man!! Awesome