Q:
Blank Cell Selecting (code) Question
I'm creating a macro, and need to select the first blank cell in a row.
My code now reads:
Range("A2").Select
Selection.End(xlToRight).Select
This selects the last cell with data, but I want to select the blank cell to the right. How would I write the code? Any help would be great.
My code now reads:
Range("A2").Select
Selection.End(xlToRight).Select
This selects the last cell with data, but I want to select the blank cell to the right. How would I write the code? Any help would be great.
ASKED:
Sep 8 2008 8:18 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
