Sub offset_property()
'Offset property is used to access the cell in a relative manner
'In below example we have set the font color of the cell to green which is placed at
'2 rows down and 3 columns to the right of cell A1
Worksheets(1).Cells(1, 1).Offset(2, 3).Font.Color = vbGreen
End Sub
What do you think on above excel macro topic? Please provide your input, comments, questions on excel macro. I will try to reply as soon as possible. I value your opinion on Excel Macros.
'Offset property is used to access the cell in a relative manner
'In below example we have set the font color of the cell to green which is placed at
'2 rows down and 3 columns to the right of cell A1
Worksheets(1).Cells(1, 1).Offset(2, 3).Font.Color = vbGreen
End Sub
What do you think on above excel macro topic? Please provide your input, comments, questions on excel macro. I will try to reply as soon as possible. I value your opinion on Excel Macros.
No comments:
Post a Comment