Find first blank cell in column if rightmost cell is non blank

If what you are saying is that column B is "complete", that is, has data in every row, and you want to find the next "free" (blank) cell in column B and then add something into the cell in column A on the same row, you could use:

Please Login or Register  to view this content.

Regards

Here is an example sheet, explaining what I am trying to do. Thanks for the time!

Please Login or Register  to view this content.

Regards

Thanks for the help so far. But I'm still missing a piece of code that I need. My vba does not reference the column to the right and look for a nonblank. What you gave me just pastes in the first blank cell. If I were to loop it, it would paste all the way down the workbook. Sorry, hard to explain what I'm trying to do.

Please Login or Register  to view this content.

Regards

Perfect!! Thank you very much for the help!

Okay... I am having trouble making the paste process repeat itself until there is a blank cell in the offset. Please help.

Please Login or Register  to view this content.

Nevermind, I figured it out.

Actually, thinking about it, it might be worth having the test earlier on. This would avoid asking the user to select a cell only to dash their hopes!

Maybe:

Please Login or Register  to view this content.

Regards