applying a formula to many rows

I need a help with applying the following formula:

=IF(ISNUMBER(SEARCH("shares";J7));"DIVIDEND"; "INTEREST")

to many rows, not only to single one. In this case I check collumn `J`(e.g. `J7`), and the formula is in column `K` (e.g. `K7`). The tricky thing is that the number of rows to which such a formula applies to is variable; it might be 50 or 500 rows.

Please Login or Register  to view this content.

but it only applies to cell K7. How to extend it to remaining rows? Thanks in advance for your help.

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

Thank you Antonio! points given and problem solved.

so you also see that I already have `Dim... As Long` at the end of the code and excel does not accept it in the code provided by Antonio.

Thanks in advance for help.