Selection of Range of cells

Selection of Range of cells

 

range("a1")="target"

range("a1:a10").Clear

range("a1","a10").Select

range("a1, a10").Select

range("a:a").Select

range("1:1").Select

range("a:c").Select

range("1:3").Select

range("a:c,f:g").Select

range("a1","c5").Select

range("a1,g1").Select

range("1:3,5:8").select

range(cells(1,1),cells(10,2)).Select

range("b3","c10").Cells(2,1).select

range("b3","c10")(10).select

range("b3","c10").Cells(5,2).select

range("b3","c10").Cells.Select

range("b3","c10")(17).select

range("b3","c10").Cells(0,1).select

range("b3","c10").Cells(-1,1).select

range(“a1”).activate

range("a1").addcomment"samplecomment"

range("a1").addcomment"createdon" & now

range("a1").Comment.Visible=True

range("a1").Comment.text"the new comment"

range("a1").Comment.Delete

range("a1:b10").Interior.Colorindex=3