Problems # Status Problem 1 VBA-Excel: Create worksheets with Names in Specific Format/Pattern. 2 VBA-Excel: Add Worksheets For All The Given Dates Except Weekends and Copy The Common Template In Each Worksheet 3 VBA-Excel: Create or Add Worksheets at the Run time. 4 VBA-Excel: Modified Consolidator – Merge or Combine Multiple Excel Files Into One Where Columns Are Not In Order 5 Excel-VBA : Open a Excel File using Another Excel File using Browse Option. 6 Excel-VBA : Insert Multiple Images from a Folder to Excel Cells 7 Excel-VBA : Prevent Changing the WorkSheet Name 8 Excel-VBA : Prevent Adding New Worksheet 9 Excel-VBA : Change Passwords for all the WorkSheets in one shot 10 VBA-Excel: Consolidator – Merge or Combine Multiple Excel Files Into One 11 VBA-Excel: Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays) 12 VBA-Excel: User Forms 13 VBA-Excel: Application.Wait OR Wait Method 14 VBA-Excel: Add/Insert multiple objects from a folder in an Excel Document. 15 VBA-Excel: Fill Excel Range Values in a 2D Array 16 VBA-Excel: Convert Numbers (Rupees) into Words OR Text - Updated Till 1000000 Crore With Decimal Numbers 17 VBA-Excel: Create Dynamic or Run-time WorkSheets using Macro. 18 VBA-Excel: SUDOKU Solver 19 VBA-Excel: WorkBook.Save Method 20 VBA-Excel: Open a Excel WorkBook 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) VBA-Excel: Create worksheets with Names in Specific Format/Pattern. VBA-Excel: Add Worksheets For All The Given Dates Except Weekends and Copy The Common Template In Each Worksheet VBA-Excel: Create or Add Worksheets at the Run time. VBA-Excel: Modified Consolidator – Merge or Combine Multiple Excel Files Into One Where Columns Are Not In Order Excel-VBA : Open a Excel File using Another Excel File using Browse Option. Excel-VBA : Insert Multiple Images from a Folder to Excel Cells Excel-VBA : Prevent Changing the WorkSheet Name Excel-VBA : Prevent Adding New Worksheet Excel-VBA : Change Passwords for all the WorkSheets in one shot VBA-Excel: Consolidator – Merge or Combine Multiple Excel Files Into One VBA-Excel: Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays) VBA-Excel: User Forms VBA-Excel: Application.Wait OR Wait Method VBA-Excel: Add/Insert multiple objects from a folder in an Excel Document. VBA-Excel: Fill Excel Range Values in a 2D Array VBA-Excel: Convert Numbers (Rupees) into Words OR Text - Updated Till 1000000 Crore With Decimal Numbers VBA-Excel: Create Dynamic or Run-time WorkSheets using Macro. VBA-Excel: SUDOKU Solver VBA-Excel: WorkBook.Save Method VBA-Excel: Open a Excel WorkBook 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) 1 2
