I need to select all cells from Row 260 onwards that have a value. and if row 260 is the only row with value then it should select only that row. I have a macro that selects only row 260 which is this
Code
Sub test()
'
' test Macro
'
Range("A260").End(xlUp).Offset(1, 0).Select
Range(Selection, Selection.End(xlToRight)).Select
End Sub
Display More
Or this which will select all the rows if there is more than one row with results.
Code
sub test()
Range("A260").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
End sub
What i cant seem to do is get the 2 to work together.