Frozen screen

[zelarra]

I'll tell you. I have the Excel that I attached, in which if I try to enter a value in any cell, it freezes and I have to close it.

Dropbox

www.dropbox.com

I thought it could be because I used OFFSET, but I used tables to avoid that problem, but it didn't solve it, so I don't know what could be happening.

I have detected that when changing data the screen freezes, and what you see in this capture happens to me. I am in the cell marked in red with yellow lines, I try to enter a value in that box and a grey box appears below (marked in red). If I accept with enter, it fills down the value that I have entered in that yellow-veined box but without moving from it.

Also, for some time now I have been having a "problem" when working with Excel: sometimes, and without knowing why, the selection of cells that you activate with F8 gets stuck or "on". No matter how many times I try to deactivate it by pressing F8 again, when I move between cells with the arrow keys, it keeps selecting the cells, so the only solution I have left is to close and reopen Excel.

This happens to me in books without macros (xlsx) as well as with macros (xlsm).

Can anyone help me?

Thanks.

 

[zelarra]

What laptop do you have? Mine is 15.6 inches and I can see it perfectly.

Well, please, someone who would be willing to give me a clue as to what it could be.

Thank you very much.

 

[zelarra]

Fix it:

Function Matriz() As Variant

    Application.Volatile

    Matriz = Hoja2.Range("J1", "Q" & Hoja2.Range("S1"))

End Function

Don't ask me why, but tables and a formula referring to a dynamic range (for example, J1#) cannot be on the same sheet.

Therefore, these dynamic ranges must be moved to a different sheet, and the data displayed through a UDF.

Thanks to all.