Skip to content
- Excel VLOOKUP Based on Date Range: How ToTo look up a value based on a date range in Excel, you cannot use VLOOKUP directly because it only finds exact…Formulas & functions
- Excel VBA Subscript Out of Range: Fixes“Subscript out of range” (Error 9) in Excel VBA means your code tried to access a collection item, array element, or worksheet…VBA & macros
- Excel Vertical Indent: How to Indent Down a CellTo vertically indent text in Excel, you cannot use a direct indent command like the horizontal one. Instead, you adjust the cell’s…How-to basics
- Excel Vehicle Mileage Log: Setup & FormulasYou can create a vehicle mileage log in Excel by setting up a table with columns for Date, Purpose, Start and End…Formulas & functions
- Excel VBA Protect Sheet Allow Format CellsYes, you can protect a worksheet in Excel VBA while still allowing users to format cells. Use the Protect method with the…VBA & macros
- Excel VBA Protect Sheet Allow Edit ObjectsYes, you can use Excel VBA to protect a worksheet while still allowing users to edit objects such as shapes, charts, text…VBA & macros
- Excel VBA Protect Cells: Lock and Unlock RangesTo protect specific cells in Excel with VBA, you must first unlock the cells you want editable, then enable worksheet protection with…VBA & macros
- Excel VBA Nested Select Case: Syntax & ExamplesThe direct answer: In Excel VBA, a nested Select Case is simply a Select Case block placed inside another Select Case block…VBA & macros
- Excel VBA Must Be First Statement on Line?No, the first statement on a line does not have to be a VBA statement at all — but if you put…VBA & macros
- Excel VBA Move to Last Row with DataThe fastest way to move to the last row with data in Excel VBA is Range("A" & Rows.Count).End(xlUp).Select (or .Offset(1).Select to go…VBA & macros
- Excel VBA: Move File to Another Folder (Step-by-Step)Yes, you can move a file to another folder in Excel VBA using the FileSystemObject.MoveFile method or the simpler Name ... As…VBA & macros
- Excel VBA Macro Training: How to StartExcel VBA macro training teaches you how to automate repetitive tasks in Excel by writing code in the Visual Basic for Applications…VBA & macros
- Excel VBA Macro to Sort Data: How to Write OneThe quickest way to sort data with an Excel VBA macro is to record a sort and then edit the generated code,…VBA & macros
- Excel VBA Macro Text: What It Is and How to Use ItAn Excel VBA macro text is the programming code written in Visual Basic for Applications (VBA) that automates tasks in Excel—it’s the…VBA & macros
- Excel VBA Macro Not Running? Fixes That WorkIf your Excel VBA macro is not running, the most common causes are macros being disabled by security settings, the workbook being…VBA & macros
- Excel VBA Macro Logo: What It Is & How to Use ItAn Excel VBA macro logo is not a built-in feature—Excel does not provide a dedicated “macro logo” tool. Instead, the term refers…VBA & macros
- Excel VBA Macro Functions: What They Are & How to UseExcel VBA macro functions are custom procedures written in Visual Basic for Applications (VBA) that you can call from a worksheet cell…VBA & macros
- Excel VBA Macro Basics: A Beginner’s GuideExcel VBA (Visual Basic for Applications) macros are recorded or written sequences of instructions that automate repetitive tasks in Excel, such as…VBA & macros
- Excel VBA Lowercase: Convert Text with UCase and StrConvTo convert text to lowercase in Excel VBA, use the LCase function: LCase("HELLO") returns "hello". For more control, such as converting only…VBA & macros
- Excel VBA Loop Through Table Column: How-ToTo loop through a table column in Excel VBA, use a For Each loop over the ListColumn.DataBodyRange or ListColumn.Range of a ListObject,…VBA & macros
- Excel VBA Loop Through Specific WorksheetsTo loop through specific worksheets in Excel VBA, use a For Each loop with a If condition that checks each worksheet’s name…VBA & macros
- Excel VBA: Loop Through Rows Until Empty (4 Ways)The simplest way to loop through rows until an empty cell is found is to use a Do While loop that checks…VBA & macros
- Excel VBA: Loop Through Folders and SubfoldersTo loop through folders and subfolders in Excel VBA, use the FileSystemObject with a recursive procedure, or the Dir function with a…VBA & macros
- Excel VBA Loop Through Filtered Table RowsTo loop through only the visible rows of a filtered Excel table in VBA, use the SpecialCells(xlCellTypeVisible) method on the table’s DataBodyRange…VBA & macros
- Excel VBA Loop Through Filtered Rows: 2 WaysTo loop through only the visible rows in a filtered Excel range with VBA, use the SpecialCells(xlCellTypeVisible) method to get a reference…VBA & macros
- Excel VBA Loop Through Controls in UserFormTo loop through all controls on a UserForm in Excel VBA, use a For Each loop over the UserForm.Controls collection, checking each…VBA & macros
- Excel VBA Loop Through Cells in a RangeTo loop through cells in a range with Excel VBA, use a For Each loop: For Each cell In Range("A1:A10") … Next…VBA & macros
- Excel VBA: Loop Through All Rows in a ColumnThe simplest way to loop through all rows in a column with VBA is to use a For Each loop over the…VBA & macros
- Excel VBA Last Visible Row: Find It FastThe fastest way to get the last visible row in Excel VBA is to use ActiveSheet.UsedRange.Rows.SpecialCells(xlCellTypeVisible).Count combined with a loop, or more…VBA & macros
- Excel VBA Last Non Empty Row: Find It FastThe fastest way to find the last non-empty row in a column with Excel VBA is Cells(Rows.Count, 1).End(xlUp).Row — this returns the…VBA & macros