Hi people,
Is there any way of knowing the number of formulas contained in a spreadsheet?
Hi people,
Is there any way of knowing the number of formulas contained in a spreadsheet?
Without code
Press F5 > special > formulas then at the bottom of excel there is a toolbar that says Ready Right click and select count.
Added a link to status bar
http://www.bettersolutions.com/excel...B913232322.htm
Added some code
VBA NoobPlease Login or Register to view this content.
Last edited by VBA Noob; 03-10-2008 at 11:09 AM.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Unless = is contained in text somewhere, you could also just run a search for that and click Find All.
Brilliant.
Thanks guys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks