Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to detect type of cell contents
Is there a formula or function that I can use that will tell me if a cell's
contents contain plain text or number that is input, or if it is a formula that is generating the results. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to detect type of cell contents
This user defined function will do the job:
Function Whattype(mycell) If mycell.HasFormula Then Whattype = "Formula" Else Whattype = "Input" End If End Function Call it with =Whattype(a1) If you are unfamiliar with VBA see David McRitchie's site on "getting started" with VBA http://www.mvps.org/dmcritchie/excel/getstarted.htm But feel free to return here with more questions , or contact me direct -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Mark" wrote in message et... Is there a formula or function that I can use that will tell me if a cell's contents contain plain text or number that is input, or if it is a formula that is generating the results. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to detect type of cell contents
Bernard, thanks for this. I would need this to check a series of cells in a
column. How do I include that logic? I am new to VBA but willing to learn. Mark "Bernard Liengme" wrote in message ... This user defined function will do the job: Function Whattype(mycell) If mycell.HasFormula Then Whattype = "Formula" Else Whattype = "Input" End If End Function Call it with =Whattype(a1) If you are unfamiliar with VBA see David McRitchie's site on "getting started" with VBA http://www.mvps.org/dmcritchie/excel/getstarted.htm But feel free to return here with more questions , or contact me direct -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Mark" wrote in message et... Is there a formula or function that I can use that will tell me if a cell's contents contain plain text or number that is input, or if it is a formula that is generating the results. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to detect type of cell contents
Copy the formula down the column
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Mark" wrote in message t... Bernard, thanks for this. I would need this to check a series of cells in a column. How do I include that logic? I am new to VBA but willing to learn. Mark "Bernard Liengme" wrote in message ... This user defined function will do the job: Function Whattype(mycell) If mycell.HasFormula Then Whattype = "Formula" Else Whattype = "Input" End If End Function Call it with =Whattype(a1) If you are unfamiliar with VBA see David McRitchie's site on "getting started" with VBA http://www.mvps.org/dmcritchie/excel/getstarted.htm But feel free to return here with more questions , or contact me direct -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Mark" wrote in message et... Is there a formula or function that I can use that will tell me if a cell's contents contain plain text or number that is input, or if it is a formula that is generating the results. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
function to display contents of a cell | Excel Worksheet Functions | |||
A challenge: referencing cell contents in nested function formula | Excel Worksheet Functions | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
What worksheet function will formatlessly copy cell contents? | Excel Worksheet Functions | |||
How can I shift cell range contents by using a function? | Excel Worksheet Functions |