If EntireRow.Delete then RefreshAll

Hi all,

I am trying to create a code using 'Worksheet_SelectionChange', that would refresh a workbook if the 'EntireRow.Delete' event is met on a specific worksheet.

So far i have come up with the below, however it does not work.

Appreciate you help.

Please Login or Register  to view this content.

.
https://analysistabs.com/vba-code/wo.../m/refreshall/

I believe you must specify which workbook.

Thanks for you response Logit.

I have tried specifying the workbook, however it doesn't work either.

I have tried another approach, however I am still getting a debug everytime I select a cell.

Code is placed in the "data" worksheet.

Please Login or Register  to view this content.

Anyone, help please?

You're using a selection change event, which is triggered everytime you select a cell that is not currently selected (e.g. you're in A1, then you click on A2) - which I don't think its appropriate here. Additionally, the EntireRow.Delete is a method, rather than an event (i.e. you're telling VBA to delete the row, and not asking whether a row has been deleted).

I could be wrong, but I don't think there is an event that can capture the deletion of the entire row. Perhaps, you can use something else that's similar and that is...

Please Login or Register  to view this content.

Utilises the change event - a macro that runs every time you change something (i.e. type in a formula or edit a cell) to the entire row (like deleting a row). It also runs when you ADD a row or key in data unto the entire row simultaneously by CTRL + ENTER - which, hopefully is acceptable for your purpose.

Thank you all that does the trick! Much appreciated.