This page lists every VBA tutorial on Statology.
Operations
VBA: How to Count Number of Sheets in Workbook
VBA: How to Count Number of Used Columns
VBA: How to Count Number of Rows in Range
VBA: How to Transpose a Range
VBA: How to Calculate Absolute Values
VBA: How to Use Wildcards
VBA: How to Check if String Contains Another String
VBA: How to Count Occurrences of Character in String
VBA: How to Use IsNumeric to Check if Cell is a Number
VBA: How to Write a Case Statement
VBA: How to Convert String to Double
VBA: How to Convert String to Integer
VBA: How to Convert String to Long
VBA: How to Convert String to Date
VBA: How to Convert Column Number to Letter
VBA: How to Replace Characters in String
VBA: How to Remove Characters in String
VBA: How to Remove Last Character from String
VBA: How to Remove First Character from String
VBA: How to Remove Spaces from String
VBA: How to Remove Leading and Trailing Spaces
VBA: How to Remove Special Characters from String
VBA: How to Remove Duplicate Values
VBA: How to Remove Borders from Cells
VBA: How to Remove Cell Fill Colors
VBA: How to Calculate Time Difference
VBA: How to Compare Dates
VBA: How to Add Days to Date
VBA: How to Subtract Days from Date
VBA: How to Calculate Days Between Two Dates
VBA: How to Convert Date to Week Number
VBA: How to Concatenate Strings
VBA: How to Split String into Array
VBA: How to Split String Based on Multiple Delimiters
VBA: How to Count Cells with Specific Text
VBA: How to Check if Cell is Blank
VBA: How to Use “If Not Blank”
VBA: How to Use IF AND to Test Multiple Conditions
VBA: How to Use IF OR to Test Multiple Conditions
VBA: How to Use IF NOT
VBA: How to Use IFERROR
VBA: How to Use MOD Operator
VBA: How to Use Formula for “If Cell Contains”
VBA: How to Sort Sheet by Multiple Columns
VBA: How to Sort Values Alphabetically
VBA: How to Filter a Column
VBA: How to Round Up Values
VBA: How to Round Down Values
VBA: How to Round Values to 2 Decimal Places
VBA: How to Use INDEX MATCH
VBA: How to Use INDEX MATCH with Multiple Criteria
VBA: How to Use HLOOKUP
VBA: How to Use VLOOKUP
VBA: How to Use VLOOKUP From Another Sheet
VBA: How to Use XLOOKUP
VBA: How to Use SUMPRODUCT
VBA: How to Refresh Pivot Tables
VBA: How to Filter Pivot Tables
VBA: How to Find Last Used Row
VBA: How to Find Last Used Column
VBA: How to Use RandBetween to Generate Random Numbers
VBA: How to Format Cells as Percentage
VBA: How to Apply Conditional Formatting to Cells
VBA: How to Apply Conditional Formatting to Duplicate Values
Descriptive Statistics
VBA: How to Write SUMIF and SUMIFS Functions
VBA: How to Write COUNTIF and COUNTIFS Functions
VBA: How to Write AVERAGEIF and AVERAGEIFS Functions
VBA: How to Calculate Average Value of Range
VBA: How to Calculate Standard Deviation of Range
VBA: How to Find Max Value in Range
VBA: How to Find Minimum Value in Range
VBA: How to Sum Values in Range
VBA: How to Count Unique Values in Range
VBA: How to Use COUNTA to Count Non-Empty Cells in Range
VBA: How to Rank a List of Values
VBA: How to Use Subtotal Function