CurrentRegion analyses the filled cells and the blank cells surrounded by the rangeyou provide. Its returns a Range object as a region in Mxn shape. Syntax: RangeObject. CurrentRegion Example: Function FnCurrentRegion() Dim mainWorkBook As...
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....
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...
You can update the multiple worksheets at the same time. If you want to do the similar action on the same range on multiple sheets, all you need to do is use Array Function...
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
Select: You can Select a cells or cells for performing many activities like putting some value in cell or doing formatting or copy-paste the data. You can put or enter values in cells with/without...
Referring Excel cells using For…Next -Loop For i = 1 to 10 Range(“A” & i).Value = 1 Next Enter ‘1’ in Cells from A1 to A10. Referring Columns of excels using For-Loop For i...