Change formula to VBA code

[Godders199]

Hello, i am trying to change all my existing formulas which were recorded into vba code, rather than paste it in and copy to last row which the current marco does.

to be honest , i am stuck on how to write the following as VBA code, could anyone help me?

=IF(SUMPRODUCT((Lists!C$1:C$7<>"")*ISNUMBER(SEARCH(Lists!C$1:C$7,'cases available '!L2))),"Estate Planning","")

thanks

 

[farmerscott]

Hi,

In your own words can you either describe what you want to do or what the formula is trying to do?

Can you give an example of your data?

thx

Farmerscott