Be the first user to complete this post
|
Add to List |
VBA-Excel: Cells Ranges Offset - Active Cell
ActiveCell, as the name clearly indicates that the cell which is presently active in your worksheet, in other words you can if u start typing the value u entered will go to active cell.
Example:
Function FnActiveCell() Dim mainWorkBook As Workbook Set mainWorkBook = ActiveWorkbook mainWorkBook.Sheets("Sheet1").Activate ActiveCell.Value = 5 End Function
You can select a specific cell in worksheet which you want to be active. Use Range object along Activate method
Function FnActiveCell() Dim mainWorkBook As Workbook Set mainWorkBook = ActiveWorkbook mainWorkBook.Sheets("Sheet1").Range("A2").Activate ActiveCell.Value = 53 End Function
You can also change the ActiveCell by using the Offset property.
Function FnActiveCell() Dim mainWorkBook As Workbook Set mainWorkBook = ActiveWorkbook mainWorkBook.Sheets("Sheet1").Range("A2").Activate ActiveCell.Offset(1, 0).Activate ActiveCell.Value = "New Cell" End Function
Also Read:
- VBA-Excel: String Functions – RTrim()
- VBA-Excel: Date-Time Functions – DateAdd()
- Message Boxes in VBA Excel (Msgbox)
- VBA-Excel: Arrays – One Dimension, Static Array