excel error.PNG

Hi All,

I am having the above issue and can't seem to figure out why.

As per the photo, when I use that offset formula, it provides me with a #Value error. However, if i debug that part using F9 then the formula works fine.

Appreciate your help.