How to solve : run-time error 91 object variable or with block variable not set

Hi All,

In the attached file, whenever a cell under column D of DM PR Availability sheet is selected as Do Not Disturb, its timestamp is captured in the sheet DND timestamps.

All was working perfectly. However, all of a sudden, when i try to select Do Not Disturb now, excel shows below error:

run-time error 91 object variable or with block variable not set

Can someone guide and resolve the issue.

Thanks in advance.

Your VBA is password-protected, so can't be read!

Sincere apologies. I forgot to mention password.

Pass= 123 for all locked sheets/VBA.

Perhaps i got the issue.

Whenever, the DND status in DM PR Availability sheet is set to Do Not Disturb, apart from the timestamp capture in DND Timestamps sheet, its count is also being captured in DM Dashboard sheet from row 7 under columns M.

Due to the pivot table additional data, the entries were moved and thereafter i am getting error. If i delete 2 columns, then all works fine.

However, i would like to remove these counts from DM Dashboard sheet since its already being captured in DND Timestamps sheet.

If not, the counts are to be moved to column AC in DM Dashboard sheet.

Can you please modify the VBA and do the needful.

Many thanks.