Determine if cell in last table row is selected

[michellepace]

Hi there,

The first code block determines if the user selects the last cell in a table and that works just fine for me.

QUESTION: Could anyone tell me in the second code block what I need to set "lastRow" to in order to determine if my user selects a cell in the last row of my table?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks in advance,
Michelle

[NeedForExcel]

Maybe

Please Login or Register  to view this content.

[protonLeah]

only tests the cells in the last row of a named range

Please Login or Register  to view this content.