VBA to find any changes in lastrow

[Vigash]

Hi All,

I am trying to find the last row using VBA in the table. I found the last row but my challenge is how to store that value and compare it with new last row.
My aim is to if any changes in the last row, it will trigger a macro.

Thanks in advance.

Regards,
Vigash

 

[kgkev]

to store the value for long term use I believe it is necessary to write it into a cell inside the workbook. I usually use a hidden worksheet.

you can then compare the new last row data to that which is stored in the hidden sheet and trigger your macro to run. if necessary your macro would also need to update the stored last row data

 

[Vigash]

to store the value for long term use I believe it is necessary to write it into a cell inside the workbook. I usually use a hidden worksheet.

you can then compare the new last row data to that which is stored in the hidden sheet and trigger your macro to run. if necessary your macro would also need to update the stored last row data

Thank you so much for the valuable advice. I was struck for 2 days. You made my day thank you so much. Thank you so much for this platform.