×

Find/Replace

VBA Code To Highlight All Instances of Word/Phrase Within A Range

VBA Code To Highlight All Instances of Word/Phrase Within A Range

What This VBA Code Does Have you ever had to search through a large Excel spreadsheet to find specific text?...

Find And Break All External Links In Excel File [Guide 2022]

Find And Break All External Links In Excel File [Guide 2022]

How To Break External Links So you're on a mission to break/remove external links from your Excel workbook, huh? Seems...

VBA To Find The Last Cell With A Specific Fill Color

VBA To Find The Last Cell With A Specific Fill Color

QUESTION How can a find the last cell on a spreadsheet based on a given color? SOLUTION This VBA macro...

How To Find And Remove Duplicate Excel Cell Data

How To Find And Remove Duplicate Excel Cell Data

Double Trouble I think we have all had our fair share of experiences getting weird outcomes because of duplicate data...

Find And Replace All With VBA In PowerPoint

Find And Replace All With VBA In PowerPoint

What This VBA Code Does This post is a follow-up article to Find And Replace With Excel VBA. The following...

Remove Unnecessary Sheet References From Excel Formulas With VBA Macro

Remove Unnecessary Sheet References From Excel Formulas With VBA Macro

What This VBA Code Does Have you ever seen a formula in Sheet1 where it is written with references to...

Classified Data: Find All Numbers And Replace Them With X’s In Text

Classified Data: Find All Numbers And Replace Them With X’s In Text

Recently I found myself in a situation where another company wanted to see the formatting of numerous reports and presentations...

Remove Plus Signs From The Beginning of Excel Formulas

Remove Plus Signs From The Beginning of Excel Formulas

What This VBA Code Does It's probably just my OCD acting up but I HATE the look of formulas beginning...

Find All Instances With VBA

Find All Instances With VBA

What This VBA Code Does This VBA macro with let you specify a value and create an Excel range selection...

Find and Replace All With Excel VBA

Find and Replace All With Excel VBA

What This VBA Code Does These VBA macros will show you various ways to find and replace all for any...

[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!

X