Problems # Status Problem 21 VBA-Excel: Create a WorkBook at Runtime. 22 VBA-Excel: CurrentRegion 23 VBA-Excel: Cells Ranges Offset - Active Cell 24 VBA-Excel : 3D-Ranges – FillAcrossSheets Method 25 VBA-Excel: Select and Activate Cells - Select 26 VBA Excel – Looping Through a Range of Cells 27 VBA Excel – Refer to Multiple Ranges : Union Method 28 VBA Excel - Cells, Ranges and Offset: Refer to Cells by Using Shortcut Notation 29 VBA Excel - Cells, Ranges and Offset: Refer Range by using A1 Notations 30 VBA-Excel: Copy/Paste data - Copy the Entire data from one sheet to another 31 VBA-Excel: Copy/Paste data - Copy the Entire row data and paste it to another row 32 VBA-Excel: Copy/Paste data - Copy the data from a call and paste it to another cell 33 VBA-Excel: Clear data from Excel Sheet(WorkSheet) 34 VBA-Excel: UsedRange 35 VBA-Excel: Get the names of all WorkSheets in a Excel (WorkBook) 36 VBA-Excel: Delete Blank Rows from Excel Work Sheet 37 VBA Excel - Cells, Ranges and Offset : Offset 38 VBA Excel - Cells, Ranges and Offset : Range 39 Message Boxes in VBA Excel (Msgbox) 40 FileSystemObject:OpenTextFile Method VBA-Excel: Create a WorkBook at Runtime. VBA-Excel: CurrentRegion VBA-Excel: Cells Ranges Offset - Active Cell VBA-Excel : 3D-Ranges – FillAcrossSheets Method VBA-Excel: Select and Activate Cells - Select VBA Excel – Looping Through a Range of Cells VBA Excel – Refer to Multiple Ranges : Union Method VBA Excel - Cells, Ranges and Offset: Refer to Cells by Using Shortcut Notation VBA Excel - Cells, Ranges and Offset: Refer Range by using A1 Notations VBA-Excel: Copy/Paste data - Copy the Entire data from one sheet to another VBA-Excel: Copy/Paste data - Copy the Entire row data and paste it to another row VBA-Excel: Copy/Paste data - Copy the data from a call and paste it to another cell VBA-Excel: Clear data from Excel Sheet(WorkSheet) VBA-Excel: UsedRange VBA-Excel: Get the names of all WorkSheets in a Excel (WorkBook) VBA-Excel: Delete Blank Rows from Excel Work Sheet VBA Excel - Cells, Ranges and Offset : Offset VBA Excel - Cells, Ranges and Offset : Range Message Boxes in VBA Excel (Msgbox) FileSystemObject:OpenTextFile Method 1 2 3