List of functions used in a particular Excel sheet
 

Hi,

I am not much of a programmer, so I was wondering if someone could help
me write a VBA function that will go through all the cells of an excel
sheet, and if a function exists in that cell, output that function to a
text file?

After having the list of functions, I'd also like to know if the
function is an excel built in function, a function local to my excel
work book, or if it is a function available through a XLA that I've
included as an add in...

Is this possible to do? or do I have to manually do it?

Thanks!


--
Duckman
------------------------------------------------------------------------
Duckman's Profile: http://www.excelforum.com/member.php...o&userid=29488
View this thread: http://www.excelforum.com/showthread...hreadid=491897

List of functions used in a particular Excel sheet
 

Duckman

You could take a look at http://www.j-walk.com/ss/excel/tips/tip28.htm you
might be able to adapt that to your purpose.

Rob

"Duckman" wrote in
message ...

Hi,

I am not much of a programmer, so I was wondering if someone could help
me write a VBA function that will go through all the cells of an excel
sheet, and if a function exists in that cell, output that function to a
text file?

After having the list of functions, I'd also like to know if the
function is an excel built in function, a function local to my excel
work book, or if it is a function available through a XLA that I've
included as an add in...

Is this possible to do? or do I have to manually do it?

Thanks!


--
Duckman
------------------------------------------------------------------------
Duckman's Profile:
http://www.excelforum.com/member.php...o&userid=29488
View this thread: http://www.excelforum.com/showthread...hreadid=491897