What it does
For the selected range, loops through all cells and removes the INDIRECT component of the formula and replaces it with a corresponding direct reference.

When to use it
When you want to quickly convert indirect references to direct references, this is a very easy way to do it.

Why to use it
It’s a quick and easy way to convert INDIRECT function references to their corresponding direct references.  Generally this is helpful when the indirect reference is to a separate file since the file must be open for an indirect reference to work.

Default shortcut
None

Other Details

• Category: Formulas / General
• Difficulty: 3/5
• Usage/frequency: 3/5
• Automation factor: 5/5 (estimated 180 seconds saved each time used)
• Type: Shortcut
• Date added: 4/12/2016
• Tags: Formula, indirect, direct

Related Macros
Show Cell References
Summarize Sheets

Other Articles
None

Remove Indirect Macro – Example File

Prerequisites
Select one or more cells containing the INDIRECT function where you want to convert the indirect reference to a corresponding direct reference.

Instructions
With the desired cells selected, run the Remove Indirect macro.  It will loop through and convert each indirect reference to its corresponding direct reference.

Note: it is highly recommended that you make a backup of the file or copy the formulas to a separate range before converting them, especially in the event that you want to reuse them later.

None