Total Pageviews

Saturday, October 27, 2018

How to Select a Cell Relative to Another (Not the Active) Cell





















To select a cell that is six rows below and six columns to the right of cell F6, you can use either of the following examples:

ActiveSheet.Cells(6, 6).Offset(6, 6).Select
ActiveSheet.Range("F6").Offset(6, 6).Select

No comments: