Excel VBA
How to Add a Sheet with a Specific Name in Excel VBA
Learn how to add a sheet with a specific name in Excel VBA, rename instantly, and insert it at a chosen location easily.
Read article
Author & Spreadsheet Consultant
Mohammed Shafin Arshad
111 Articles PublishedPublishing since
Mohammed Shafin Arshad is a Computer Science student and cybersecurity enthusiast in Malaysia with 6 years of Excel and Google Sheets experience. He specializes in VBA, macro automation, and SaaS-focused workflow guides. His background includes university data science projects, and he enjoys using macros to solve complex spreadsheet problems.
Editorial Review
Articles Published by Mohammed Shafin Arshad
Articles by Mohammed Shafin Arshad are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Excel VBA
How to Fix 'Loop Without Do' Error in VBA (3 Quick Solutions)
Fix the Loop Without Do error in VBA by pairing Do and Loop correctly, using For…Next loops, and matching loop placements properly.
Read article
Excel VBA
Fix Object Variable or With Block Variable Not Set Error in VBA
Fix the Object Variable or With Block Variable Not Set error in VBA by declaring, setting objects correctly, and checking for Nothing.
Read article
Excel VBA
How to Pass Variables from a UserForm to a Module in Excel VBA
Learn how to pass variables from a UserForm to a module in VBA using public variables, properties, and hidden forms effectively.
Read article
Excel VBA
Differences Between Function and Sub in Excel VBA
Understand the difference between Function and Sub in VBA, how they return values, run actions, call procedures, and work in Excel cells.
Read article
Excel VBA
Macro to Copy Data from Another Workbook Based on Criteria
Learn how to create Excel macros to copy data between workbooks based on single or multiple criteria using advanced filters.
Read article
Excel VBA
How to Autofit Column Width with Excel VBA (5 Examples)
Learn how to autofit column width in Excel using VBA—covering Range.AutoFit, UsedRange, visible cells, and automatic event-based fitting.
Read article
Excel VBA
Macro Buttons Not Working in Excel (4 Quick Fixes)
Fix Excel macro buttons not working with these 4 quick solutions: enable macros, save as .xlsm, reassign, and disable design mode.
Read article
Excel VBA
How to Add Pop-Up on a Button to Select a Macro in Excel VBA
Learn how to add a pop-up on a button in Excel VBA to select and assign macros using Form Controls or Shapes effectively.
Read article
Excel VBA
How to Select an Entire Row of Active Cell Using Excel VBA
Learn how to select the entire row of the active cell in Excel VBA using ActiveCell.EntireRow, Rows, and the Union method.
Read article
Excel VBA
Private Sub vs Sub in Excel VBA: All You Need to Know
Learn the difference between Private Sub and Sub in Excel VBA, with examples on scope, access control, and modular macro design.
Read article
Excel VBA
How to Find Exact Matches Using Excel VBA (6 Examples)
Learn how to find, replace, and extract exact matches in Excel using VBA, including case-sensitive searches and the MATCH function.
Read article