Excel VBA
How to Convert Numbers to Strings in Excel VBA (3 Examples)
Learn how to convert numbers to strings in Excel VBA using CStr, Str, and Format functions for flexible and accurate data formatting.
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 Check if an Array Is Empty in Excel VBA (3 Ways)
Learn how to check if an array is empty in Excel VBA using IsEmpty, Join for string arrays, and custom functions with UBound and LBound.
Read article
Excel VBA
How to Split a String into an Array in Excel VBA (4 Examples)
Learn how to split a string into an array in Excel VBA using Split, Replace, InStr with Mid, and Regex for handling delimiters & patterns.
Read article
Excel VBA
How to Filter with Multiple Criteria in Excel VBA
Learn how to filter data with multiple criteria in Excel VBA using AutoFilter, AdvancedFilter, and logic-based filtering across ranges.
Read article
Google Sheets Functions
How to Show 0 Instead of Blank in Google Sheets
Learn how to show 0 instead of blank in Google Sheets using IF, IFERROR, ISBLANK, ARRAYFORMULA, N function, or Apps Script for full control.
Read article
Google Sheets Functions
Google Sheets QUERY GROUP BY Multiple Columns (3 Examples)
Group data by multiple columns in Google Sheets using the QUERY function. Learn to filter with WHERE and sort results for better insights.
Read article
Excel VBA
How to Create a Macro to Send Email from Excel Using VBA
Learn how to create a macro in Excel using VBA to send emails via Outlook, preview messages, and automate emails based on cell values.
Read article
Excel VBA
How to Use AddItem with ComboBox in Excel VBA
Learn to use AddItem in Excel VBA to add items to ActiveX ComboBoxes on worksheets and populate UserForm ComboBoxes efficiently with code.
Read article
Excel VBA
How to Add Radio Buttons (Option Buttons) in Excel
Add radio buttons in Excel, group them for exclusive choices, link to formulas, and enhance functionality with Form and ActiveX controls.
Read article
Excel VBA
How to Use UserForm in Excel VBA with Practical Examples
Learn to create and use Excel VBA UserForms with practical examples, from simple inputs to multi-page forms with pre-populated controls.
Read article
Excel VBA
How to Use On Error GoTo 0 in Excel VBA for Error Handling
Learn how to use On Error GoTo 0 in Excel VBA to restore default error handling after skipping expected errors like missing sheets or files.
Read article
Excel VBA
How to Use On Error Resume Next in Excel VBA for Error Handling
Use On Error Resume Next in Excel VBA to handle missing shapes, detect absent sheets, and manage errors in VLOOKUP loops efficiently.
Read article