Problem The title is fairly self-explanatory re: my goals, though I’ll add that speed/efficiency is a priority. Originally, I tried […]
Category: VBA
Find and copy pasting optimisation
Problem I am trying to apply this simple macro to merge two big sized sheets (around 30000 rows each), but […]
Excel VBA to Fetch email addresses from inbox and sent items folders
Problem I am using the following VBA to fetch multiple specified Email addresses from inbox and sent items folder also […]
VBA Excel – Conditional Formatting Colour Grab
Problem This code gets the cell’s colour regardless of whether it’s set from conditional formatting or not. It currently works […]
A function that replicates DLookup, and can use parameterized queries
Problem This function was built to replace DLookup so that i could pass in parameterized queries for a speed increase. […]
How to check if workbook not corrupted
Problem I have asked this on the main stackoverflow.com site, but I have been redirected here. My problem is, how […]
Excel VBA highlighting macro
Problem I have this Excel macro I created to highlight all instances of a number if at least one instance […]
Copying and comparing two sheets before deleting duplicates
Problem I am running this code as a macro in Excel, which copies two columns from sheet 1 and pastes […]
Index Match implementation
Problem The code below takes header variables, retrieves the column index, and then, using an Index/Match function, returns data from […]
Comb Sort in VBA
Problem Playing off Robust Bubble Sort in VBA and as suggested by @Henrik, I took a look at comb sort […]