Function for getting cell ID and the last row with value

[Shaijuzacharia]

Hi,
Please give me a solution in finding the cell ID which contains the
specific text given.
Also how can we find the last row with value.

Thanks,
Shaiju

 

[Max]

See Roger's response to your earlier posting

 

[Roger Govier]

take a look at your earlier posting. I gave a solution there.