Is there a function to determine whether a cell contains a formul.

C

Christo Kriel

I need to use an Excel function to check whether a cell contains a formula. I
want to design a spreadsheet test for my class which checks itself and gives
feedback on whether the answers are correct.
 
F

Frank Kabel

Hi
try the following UDF:
public function is_formula(rng as range)
is_formula=rng.hasformula
end function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Page numbering with Merged Document and IF statements 1
Excel Formula - If Cell contains word and select it from a list? 0
Nested If Statement help 1
Compressing multiple functions across an array into one cell 6
How do I evaluate whether a character is present in a cell? 4
Function to determine if a cell contains a formula 5
Need help finding a substring in a array of strings. 1

Top