Listing all formulas in workbook

**Bonnister** · 08-28-2015, 11:39 AM

Hello everyone

After a bit of research I've written the following macro to supposedly generate list of all formulae in a workbook I've been building for several weeks:

Please Login or Register  to view this content.

But everytime I try to use it I get a 'Run Time Error 1004: No cells were found'! The workbook I'm using this on has thousands of individual formulae in it...

Is there something wrong with this macro, because I'm struggling to see what I need to do to correct this and get it working? Or has anyone got an alternative method to just list all formulae?

Thanks
Kenny

**TMS** · 08-28-2015, 11:49 AM

Well, one thing you don't appear to do is skip the sheet where you plan to store the formulae. That could be the source of the problem.

But why would you spend hours researching and developing code for yourself?