Total Pageviews

Thursday, October 25, 2018

How to Select a Range of Cells on the Active Worksheet
















To select the range B2:D4 on the active worksheet, you can use any of the following examples:

ActiveSheet.Range(Cells(2, 2), Cells(4, 4)).Select

ActiveSheet.Range("B2:D4").Select

ActiveSheet.Range("B2", "D4").Select