Selecting rows which contain cells that use formulas

[rayken]

I searched quite a bit for this on Google and also within this forum, but couldn't find my situation, so I am posting it now in hopes that it might be solved for others also.

I am needing to select all rows in a worksheet that contain cells which use formulas. I know of the "Find & Select" -> "Formulas" method, but that only selects the cells which use formulas, and I would like to select those entire rows. Not sure if this will require a macro or not, but thanks in advance if anyone can point me in the right direction.

[romperstomper]

You could use a macro like:

Please Login or Register  to view this content.

[rayken]

Tried this out and it's exactly what I was wanting. Repped, and thank you!

[Marcol]

Try this

Please Login or Register  to view this content.

Hope this helps

Late again!!! Did not see the previous posts!!! Why does my browser not refresh in sync with the forum?

Why does this happen so often???