Extractign a forumla from a cell

[Legacy 93538]

Hi

Does anyone know how to extract a forumla from a cell?

I have a macro which loops through a cell range and I need to add to this so that it says if the cell has a forumla which starts with SUM then. I have tried:

If cell.forumla = "SUM*:*" Then

Would haveing .value work?

Thanks

Jeskit

 

[Andrew Poulsom]

Maybe:

If Left(cell.Formula, 4) = "=SUM" Then

 

[Legacy 93538]

Hi

Thanks for replying.

Your code works great thank you.

Also do you know of a way to do the same code but to change it so its looking for a forumla with this construct "=*/*" ? Would the mid function work?

 

[Andrew Poulsom]

Try:

If cell.Formula Like "=*/*" Then