myRow = Cells(Rows.Count, 2).End(xlUp).Row
 

Can someone explain to me what this piece of code is supposed to do?

myRow = Cells(Rows.Count, 2).End(xlUp).Row

myRow = Cells(Rows.Count, 2).End(xlUp).Row
 

seems to return the last row in column 2 that contains data

myRow = Cells(Rows.Count, 2).End(xlUp).Row
 

find the last row in column 2 that has data.

goto B65536. Then hit the end key and then the up arrow.

that is what it essentially does.

--
Regards,
Tom Ogilvy


"Dave F" wrote:

Can someone explain to me what this piece of code is supposed to do?

myRow = Cells(Rows.Count, 2).End(xlUp).Row

myRow = Cells(Rows.Count, 2).End(xlUp).Row
 

returns the row after the last "used" row - <possibly worded incorrectly

"Dave F" wrote:

Can someone explain to me what this piece of code is supposed to do?

myRow = Cells(Rows.Count, 2).End(xlUp).Row

myRow = Cells(Rows.Count, 2).End(xlUp).Row
 

Thanks all; this is helpful.

On Jun 19, 9:13 am, Tom Ogilvy
wrote:
find the last row in column 2 that has data.

goto B65536. Then hit the end key and then the up arrow.

that is what it essentially does.

--
Regards,
Tom Ogilvy



"Dave F" wrote:
Can someone explain to me what this piece of code is supposed to do?

myRow = Cells(Rows.Count, 2).End(xlUp).Row- Hide quoted text -

- Show quoted text -