Grab the Free VBA Quick Reference Guide
[ Ссылка ]
Returns a Range or Cell object that represents a range that is offset from the specified range or cell. The syntax is offset(rows,columns) and positive numbers move down and to the right and negative numbers move up and to the left for rows and columns
Sub Off()
Range("B10").Offset(1, 1).Select
Cells(10, 2).Offset(2, 1).Select
Range("B10:C15").Select
Range("B10:C15").Offset(1, 1).Select
End Sub
Using Offset for Ranges in Excel VBA - Code Included
Теги
vba offset examplevba offset codevba offset cellsexcel vba offsetvba offset formulavba offset one row downvba offset functionvba offsetvba offset explainedvba offset rangevba offset exceloffset vbavba offset active cellvba offset select rangeexcel vba offset select rangevba offset valuevba offset cell valuevba offset range of cellsselect cells using offset vbaexcel vba sum offset cellswhat is vbaexcelvbamacrosexcel vbatutorial