find next blank cell within range

Hi again

I have a range C6:AD2506, this is my data entry range.
I have a user form with a button saying ' show me' which i want to take the user to the 1st blank cell within that range. Also when this is clicked I would like for it to remain visible so vbModeless and for the text on it to change to 'next'. And when clicked again it will go to the next blank cell, continuing until it has gone through them all.

Within my range C6:AD2506 i have mandatory fields. I only want the button to take the user to blank cells within these mandatory columns.

Also I dont want entirely blank rows to be included in the search. These are flagged up in the A column. For rows to be included in the search it says "Item" in the A column, for rows not to be included it will says "Item."

What code should I use for this set up?

Here is an attachment of the data entry sheet..the mandatory fields are marked with red cells.

OK iv started with this code :

Please Login or Register  to view this content.

This seems only to select cell C6 and do nothing from there. I am planning on starting simple and building it up to my end result!

Any help with the next step (making it find the 1st blank cell, then once clicked again find the next one)????

ok sorry.

I have used the code below to find the blank cells...for my range....and it works fine. I just cant figure out how to make the rows marked "Item." not be included in the selections. (please see original post..above).

Please Login or Register  to view this content.

Any ideas on how I should change this code so that the rows marked "Item." are not included????

Let me know, Thanks

thanks...that works perfectly :D