Hi all, I currently have this code to select data in a row. I need the macro to always select the cell one to the right of the highlighted selection (ie. the next blank cell in the row) How would I do this? Appreciate any help ,thanks! 

    Range("F21").Select
    Range(Selection, Selection.End(xlToRight)).Select