Recursive
Excel » VBA » Recursive »
List files in a folder and subfolders [UDF]
This blog post describes how to list files in a folder and subfolders using vba. Where to copy vba code? […]
Files and folders
Copy data from workbooks in folder and subfolders
Search for a file in folder and subfolders (VBA)
Find and replace a text string in file names, folder name and subfolders
Unzip files in folder and subfolders
Filter duplicate files in a folder and sub folders
Compare file names in two different folder locations and their sub folders
Search all workbooks in a folder and sub folders
Search all workbooks in a folder
Find out if excel files in a folder are password protected
Insert hyperlinks to all files in current folder
Open Excel files in a folder [VBA]
Identify duplicate files in excel
List files in a folder and subfolders [UDF]
Recursive
List files in a folder and subfolders [UDF]
User Defined Function
Convert column number to column letter
Search for a file in folder and subfolders (VBA)
How to use the SPLIT function [VBA]
Count cells by cell and font color
Substitute multiple text strings [UDF]
Lookup multiple values in one cell [UDF]
Learn how to return values depending on how you enter the UDF
Two-way lookup using multiple tables [UDF]
Sumif across multiple sheets [UDF]
List files in a folder and subfolders [UDF]
Filter unique distinct records (case sensitive)
Filter unique distinct values (case sensitive) [Excel UDF]
Filter emails from an excel range [UDF]
Find positive and negative amounts that net to zero [UDF]
List permutations without repetition [UDF]
List permutations with repetition [UDF]
Filter values existing only in one out of two ranges [UDF]
Filter values in common between two cell ranges [UDF]
Filter duplicates in a large dataset [UDF]
Count unique distinct values in a large dataset [UDF]
Remove duplicates from a large dataset [UDF]
Filter unique words from a range [UDF]
Filter unique distinct words from a cell range [UDF]
Filter duplicate words from a cell range [UDF]
Split words in a cell range into a cell each [UDF]
Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel CourseMost used functions
COUNTIF function INDEX function IF function SUM function SUMIFS function SUMPRODUCT function VLOOKUP functionExcel » VBA » Recursive »
-
Welcome! I am Oscar and here to help you out.Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
-
Free Blog Emails
Get a free PDF book!
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup