Search all modules and macros to find reference

[jebenexcel]

Hello,

I have a myriad of macros by different authors in one file. One of them deposits a value in a certain cell. How do I search all of the macros in the workbook for the variable, deposited in this cell?

 

[RoryA]

You can use the Find dialog in the VB Editor to search the entire project.

 

[jebenexcel]

yeah, I tried that but couldnt find the cell because it was pasted in as part of a range.
Found it later though.