Select row, column

There are exercises too, today using what you learnt yesterday.


#1
Sub selrow()
ActiveSheet.Select
Range("A1:E1").Select
'exercise - add code to give message when row is selected
End Sub


#2
Sub selcol()
ActiveSheet.Select
Range("A1:A10").Select
'exercise - add code to give message when row is selected
End Sub


Also, if you have time, find out how you can select an entire column. In the above example, we're selecting just a small range.