don't understand coding...

**dan2010** · 08-18-2010, 12:46 AM

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

**DonkeyOte** · 08-18-2010, 02:16 AM

dan2010, could you first please retitle your thread to something more appropriate - perhaps: "Syntax Confusion"

at which point we will be able to answer your question

**dan2010** · 08-18-2010, 10:06 AM

ok. sorry abt tt

**royUK** · 08-18-2010, 10:15 AM

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.