Tried google search but have not found what I am looking for. I am trying to select the rows of all currently selected cells.
I have done the go to (f5) to highlight blank cells in a column, now I want to select all the rows with the blank cells in that column.
Have seen how to hide the rows, delete the selected cells, but cannot find how to select all rows of current selected cells.
Thanks,
Last edited by jdskin2; 02-09-2012 at 03:36 PM.
You might need to use macro to do that
Look at the attached to see if that's what you're looking for.
To thank someone who has helped you, click on the star icon below their name.
I hate reading
Portfolio
I need a job.I am young and incompetent
I think that will work perfectly, have been using an extra column and IF formula to sort out the blanks but this will help me reduce that step.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks