Hi guys,


I have got the following problem. I have a sheet "calculations" that uses references from another sheet "calendar". In the calculations sheet I have got formulas - =COUNTIF(Calendar!$B4:$AF4,"P"), =COUNTIF(Calendar!$B5:$AF5,"U") and so on. In other words, I use some references from the calendar sheet. I have got a userform with delete button which deletes the entire row in the calendar sheet and also the same row in the calculations sheet. However, the row above the deleted one in the calculations sheet gets distorted with #REF! error. The references are lost for some reason. This all is done automatically by a macro. I have read some articles about the indirect function that may help. However, I am not quite sure how to use it.

Any ideas?

Thanks