debugging - Macro VBA script -


can me problem. have code doesn't work. wrong says "sub or function not define".

sub macro1() ' ' macro1 macro ' dim x integer, result string  x = 2  ' 1st row  while cells(x, 4).value = 1        if cells(x, 3).value <= cells(x, 2).value , not cells(x, 4).value < cells(x, 1).value       result = "pass"        else       result = "fail"        end if       cell(x, 5).value = result        x = x + 1 loop  end sub 

change cell cells , work. excel wasn't being helpful enough error message. select text cell when have editor open , try run it.

sub macro1() ' ' macro1 macro ' dim x integer, result string  x = 2  ' 1st row  while cells(x, 4).value = 1        if cells(x, 3).value <= cells(x, 2).value , not cells(x, 4).value < cells(x, 1).value       result = "pass"        else       result = "fail"        end if        cells(x, 5).value = result        x = x + 1 loop  end sub 

Comments

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -