Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel List functions and linking cells | Excel Discussion (Misc queries) | |||
List of Excel 2003 Functions | Excel Worksheet Functions | |||
How to get the complete list Excel Worksheet Functions | Excel Worksheet Functions | |||
Using Excel link (hyper?) and list functions | Excel Worksheet Functions | |||
How can I print out a list of statistical functions in Excel (I d. | Excel Worksheet Functions |