Macro that searches a column for all the blank cells then highlights the row entire row.

Hi all,

As stated above I am attempting to create a macro that will search a specific column for all the blank cells and highlight/selct the entire row, then copy the highlighted/slected rows to a new spread sheet.

So far I can search and highlight all blank cells within a range however when I add to the macro to allow it to highlight the entire row it only selects the first blank cell rather than all of them.

Any and all inputs would be greatly appreciated and any suggestion to improve the macro further would also be welcome.

Thanks,

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

I will do it for you this time.