ExcelBanter - Help Identifying code statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help Identifying code statement (https://www.excelbanter.com/excel-discussion-misc-queries/167773-help-identifying-code-statement.html)

Ayo

Help Identifying code statement

Can anyone tell me what these codes do? Or what they mean?
Thanks
lastrow = Worksheets(1).Range("B65536").End(xlUp).Row
rw = Worksheets(1).Range("B65536").End(xlUp).Row + 2

JMB

Help Identifying code statement

lastrow = Worksheets(1).Range("B65536").End(xlUp).Row

Identifies the last row in column B of the first worksheet that has a value
or formula.

rw = Worksheets(1).Range("B65536").End(xlUp).Row + 2

Identifies the last row in column B of the first worksheet that has a value
or formula and adds 2 to it.

"Ayo" wrote:

Can anyone tell me what these codes do? Or what they mean?
Thanks
lastrow = Worksheets(1).Range("B65536").End(xlUp).Row
rw = Worksheets(1).Range("B65536").End(xlUp).Row + 2

All times are GMT +1. The time now is 01:47 AM.