Select next blank row in table of data

[adam2308]

In the attached example, I have a rather large table of data and I want to add a button to the top of the worksheet that when I press it, the code find the first blank cell in column B and selects that cell. I have found code that can do this (albeit slow to execute for some reason) but I also want the screen to refocus to that cell.

Here is the code I currently have:

Please Login or Register  to view this content.

[Bishonen]

Please Login or Register  to view this content.

should do the job