hi,
i have just started on vba not long ago and have been looking at many examples.
can anyone explain to me the meaning of the coding?
does "range B:B"means entire column b?
what is the function of ".rows.count,1" ? count number of rows for the 1st column?
what is the function of ".end(xlUp).row?

thanks 

With Sheets(1).Range("B:B")
            LastRow = .Cells(.Rows.Count, 1).End(xlUp).Row + 1
        End With