Formula error when filldown is used.

  • Hi, if my data only has one row below the header row it drags down the header title instead of "Pass"or "False" as it should. Works OK with more than 2 rows. See attached example. I no longer use it as a table, although the problem is still there when it is a table.

    Range("J7").Formula = "=IF(RC[-1]>=RC[-2],""PASS"")"
    'filldown the empty column using column A to determine the length of data
    Range("J7:J" & Cells(Rows.Count, "A").End(xlUp).Row).filldown

    Any help will be very much appreciated, cheers Cobber

Participate now!

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