Finding the rownumber in excel sheet

[marcusr]

Hi,

I have created a register in excel containing information about members in a sports club. I have made a form which helps the user to add new members to the register. A procedure will check if the new member added matches with any of the existing members. If not, the new member will be added in the end of the register (the last free row). This is done by using the following code:

Please Login or Register  to view this content.

where Lastrow is defined as an Object.

I now need to know the code/expression required to get the actual row number of "Lastrow" (ie say that the list contain 9 names, then the new member would be added on row 10). How do I get this row number?


Thx

Marcus

[Leith Ross]

Hello Marcus,

Your current code has LastRow as a Range Object. You can get the Row in 2 ways...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[marcusr]

Your tip worked perfectly fine.

Thx!

Marcus

Hello Marcus,

Your current code has LastRow as a Range Object. You can get the Row in 2 ways...

Please Login or Register  to view this content.

Sincerely,
Leith Ross