How can I copy all cells with "!" in formula and paste values on top of them?
<p>I'm an absolute zero beginner in VBA, and the only thing I know is what I intend to do is not possible via available features in Excel and needs a VBA code. So if anyone is willing to kindly help, I would need a complete VBA code ready to run! Thanks.</p>

<p>Task: In a very large sheet, I need to copy all cells (scattered around) containing "!" in their formula (i.e. all cells that refer to other sheets), and replace them with their respective values (similar to 'paste values'). The aim of this task is to eliminate all references to other worksheets to achieve a completely standalone sheet, while keeping all values intact.</p>

<p>So I guess what I need is a loop which goes through the whole sheet, copies a cell if it has an exclamation mark in its formula, and pastes the value in the exact same place. The loop should cover the whole sheet.</p>

<p>Does that make sense?</p>