Category: Cells Ranges Offset


VBA-Excel : 3D-Ranges – FillAcrossSheets Method

  By using FillAcrossSheets you can copy the Range of one worksheet to other multiple worksheets. Steps: Create an array and assign multiple worksheets names ( in which the data to be copied), as...


VBA-Excel: Select and Activate Cells – Activate

Here is something interesting for you, you can use a Activate method to activate a cell within a selection. Activating a Cell Within a Selection Sub ActivateCellInSelection() Worksheets(“Sheet4”).Select Worksheets(“Sheet4”).Range(“A1:H6”).Select Worksheets(“Sheet4”).Range(“D3”).Activate End Sub


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...


VBA Excel – Cells, Ranges and Offset : Offset

Offset: Offset property in VBA-Excel is used along with Range. With the help of Offset property user can move around in the sheet. Format: Range(“StartingPoint”).Offset(NoOfRowsToBeMoved , NoOfColumnsToBeMoved) Example : Range(“A2”).Offset(1,0).Select And compiler reads, move...

Show Buttons
Hide Buttons
%d bloggers like this: