counting cells - strikethrough text

Hi there,

I need to count cells that have strikes through the text, in a particular range with certain criteria. Can you give me some ideas how you would approach this with formulas?

Thanks

Martha

this UDF

Please Login or Register  to view this content.

inserted in a standard module
will return true or false for a single cell
us as normal function
i.e.
=IsStriked(A1)
prhaps you can start with that

Unfortunately, I am not familiar with VBA. I have created macros etc. but thats the extent of my current knowledge. I need to follow the steps to understand why I'm entering the data. Is there a basic VBA tutorial I can educate myself with on line?

Thanks again!

Martha

heres a quick walk through
http://www.contextures.com/xlvba01.html
once in module
you wont have to run it tho
if you use insert /functions scroll down to user defined and you will find it in there