Select all cells in a column up to a blank cell
"nemadrias" wrote in message
ups.com...
Hi -
Can anyone tell me how to select all cells in a row up to (not
including) the first blank cell in the row?
Thanks alot!
High try playing around with this in row 1
Sub SELECTROW()
'
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
End Sub
Best N10
|