compiling a function to search for strike through titles using a cell and a range as input

[yarivland]

Hi All,

I am a new bee for all Excel VBA programming, and I have to say that it is an amassing tool - that I have to learn how to use it.

I have been trying to compile a VBA function that gets an input of a cell location (A2 for example) and a range of cells to look for, in order to count the amount of strike through titles that have the same content as A2 cell.

my aim is to copy the function on a large amount of rows, and that my "Cell Location" input will follow the row number.

please find bellow the code that I have compiled:

Please Login or Register  to view this content.

the amasing thing is that if I change the variable in line 6 instead of "Crng" to a specific cell like "A2" - everything works, but the end result of this function will provide only the amount of strike through font of the title in cell A2.

I want to be able to copy the function on a large amount of cells and let the cell input follow the row number.

hopefully you will be able to fix the small issue in hand.

Appreciate your help and support,

Yariv

[Kaper]

With sample file would be easier to test, but try:

Please Login or Register  to view this content.

PS. plaese follow our http://www.excelforum.com/forum-rule...rum-rules.html : edit your post and apply code tags.

[yarivland]

Wow, Kaper you were extremely quick .... thank you for your modification.

your solution works perfectly well for me, but I wonder why did not it work using my initial code?

Appreciate your help and awaiting for your explanation.

Yariv.

[JBeaucaire]

In your line of code

Please Login or Register  to view this content.

...you inadvertently tried to use a range object as if it were a text string.