Hi guys,

I started a post yesterday, and have made some headroom, but still nee
some assistance.

I have been working on some code such that if three consecutive cell
meet a certain criteria (i.e are blank), the entire row of the thir
blank cell is selected.

Thats not where my code will end, but think I will be able to mov
along from there, or at least I will hope.

Simply put, if cells k5,k6,and k7 are all blank, the entire 7th row i
selected and stops at that point. Ideally, i would love to have i
search if three consecutive rows are entirely blank and select th
third row, but I do not know if that is possible.

Ive had some code that either would select rows that met this criteri
and kept going, or selected rows that did not meet this criteria, but
can not seem to stick the code for this one.

I am relatively new to VBA, but feel that I have a strong enoug
background to work through code should I see it.

Any help will be greatly appreciated.

Broc

--
Message posted from http://www.ExcelForum.com