Im ashamed to admit i cant figure this out. I have a bunch of data in the sheet and i want a macro to look for the first row with nothing in it and select it.