Be the first user to complete this post
|
Add to List |
VBA Excel - Cells, Ranges and Offset: Refer to Cells by Using Shortcut Notation
You don’t have to type Range every time, you have shortcut for that, ‘Brackets’.
Shortcut for referring one cell.
Worksheets("Sheet1").[G5].Interior.ColorIndex = 45
Instead of using Range(“G5”), you can use [G5].
Shortcut for referring range of cells.
Worksheets("Sheet1").[E3:F5].Value = 4
Instead of using Range(“E3:F5”), you can use [E3:F5].
Shortcut for referring more than one cell.
Worksheets("Sheet1").[G5,F9,H6].Interior.ColorIndex = 45
Instead of using Range(“G5”,”F9”,”H6”), you can use [G5,F9,H6].
Also Read:
- VBA-Excel: Modified Consolidator – Merge or Combine Multiple Excel Files Into One Where Columns Are Not In Order
- VBA-Excel: WorkBook.Save Method
- VBA-Excel: Consolidator – Merge or Combine Multiple Excel Files Into One
- VBA-Excel: Select and Activate Cells - Select
- VBA-Excel: String Functions – RTrim()