Resize is displaying one extra row

Hello,

bad logic ! Just obviously use Range("J2:J" & Cells(Rows.Count, 1).End(xlUp).Row).Formula …

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

Thanks Marc L. That worked perfect. To understand the code, If I want to resize with D instead of A I have to change Count 1 to Count 4. Tell me if I am right.

That's it ! Anyway you can use your original Range syntax.

Do not confuse the last row index and the resize rows # …

Please Login or Register  to view this content.

[CODE]Range("Y7:Y" & Cells(Rows.Count, 1).End(xlUp).Row).Formula = "=VLOOKUP(X7,'B2B HP'!$R:$Z,9,0)"[/CODE
I have to change it in multiple places. Is this is edited correct ? If this is correct, then I will edit all accordingly.

I tested at 2 places and got it corrected. Thank you very much Marc L