Category: Excel WorkBook


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 – 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: Clear data from Excel Sheet(WorkSheet)

VBA-Excel: Clear data from Excel Sheet(WorkSheet) Format: WorkBook.WorkSheet.Range.Clear          Examples: mainworkBook.Sheets(3).UsedRange.Clear Clear data from particular cell: Dim mainworkBook As Workbook Set mainworkBook = ActiveWorkbook mainworkBook.Sheets(“MyFirstMacro”).Range(“A2”).Clear


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: