Searching for function usage in Excel VBA

sparc_spread

I have inherited an Excel spreadsheet with many VBA functions and it's not clear where (or even if) a lot of them are being used.

Is there a way to find the usage of a VBA function, or perhaps search for invocations of it, similar to the way you can click on a function/method in a standard IDE and find its usage throughout the codebase? I am looking for the cells from which the functions could be being called, not invocations from within other VBA functions.

TheEngineer

In VBA - Use CTRL+F and select "Current Project" to find each usage of the function name in the project.

On Worksheet - Use CTRL+F and make sure "Look In" is set to "Formulas." Then click "Find All" to find each usage of the function name in the worksheet.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Excel VBA for searching in mails of Outlook

From Dev

Searching over multiple columns in excel vba

From Dev

Searching for a non-numeric value in VBA Excel

From Dev

Searching Outlook email (and replying to it) using Excel VBA

From Dev

Excel VBA Macro: Searching For Blank From Selection

From Dev

Searching for a folder within a folder (Excel- VBA)

From Dev

Excel function to VBA

From Dev

Excel not finding VBA Function

From Dev

Excel VBA and Group function

From Dev

Sub or Function in VBA Excel

From Dev

VBA Excel If statement with AND/OR function

From Dev

Find Function in Excel VBA

From Dev

Automate a Excel VBA Function

From Dev

Excel VBA hlookup function

From Dev

Excel VBA and Group function

From Dev

Round function VBA EXCEL

From Dev

Excel VBA: Searching for value in listbox based on value set in textbox

From Dev

Searching an excel with two search words (multiple lookup) using vba macro

From Dev

Excel VBA Debug: Loop not searching through the whole range

From Dev

Excel VBA: Searching for value in listbox based on value set in textbox

From Dev

usage of WorksheetFunction.Year in excel vba For loop

From Dev

Hashing Algorithm Usage in Searching

From Dev

What function should I use in Excel for searching a (multiple) text string?

From Dev

VBA Excel - Variable "Double" as function

From Dev

#NAME? error in Excel for VBA Function

From Dev

excel VBA return result of function

From Dev

excel VBA - function to parse data

From Dev

Excel Vba sumif function array

From Dev

Dynamic Function Calls in Excel VBA