VBA: Select and Special Select functions

Test

Try the code bellow, you can see the different selection pf cells.

1. Sub SelectAll()
   
2.     ActiveSheet.Range("B3").End(xlDown).Select
   
3.     'ActiveSheet.Cells.Select  -- This is really select all sheet.
   
4.     Range(Range("A1"), ActiveCell.SpecialCells(xlLastCell)).Select
   
5.     Range("D7").Select
   
6.     Range(Range("D7").End(xlUp), Range("D7").End(xlDown)).Select
   
7.     Range(Range("B33").End(xlToLeft).End(xlUp), Range("B33").End(xlDown).End(xlToRight)).Select
   
8. End Sub
   

复制代码