use variable for math operator

  • Re: use variable for math operator


    Try using Evaluate:


    Code
    If ActiveSheet.Evaluate(Val(Cells(i, 10)) & fnct & crit) Then

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!