If only 2 rows, skip first... more info in thread text

[srosk]

Hi there, so I have the following code. it works great, if there are 3 rows or more. But if there are only 2 rows, the script copies down from B1, instead of essentially doing nothing. I do not want the header to overwrite B1. Is there an easy fix? I tried offset, but I don't think that works in this situation?

Range("B2", "B" & Cells(Rows.Count, 1).End(xlUp).Row).FillDown

Ty as always

 

[DanteAmor]

    u = Cells(Rows.Count, 1).End(xlUp).Row
    If u > 2 Then
        Range("B2", "B" & u).FillDown
    End If

 

[srosk]

Magic! Thanks

 

[DanteAmor]

You're welcome