i want to delete cell K13, but appear the warning box. Any solution?
So working with arrays in excel can be a tricky thing. You cannot delete a cell that is a part of a bigger array.
I do it as below but others may find it another way:
If this is a one-time report you could simply highlight both columns, right click and select 'Copy', and then while it is all still selected right click and paste values only (The symbol with a clip board and '123'). This action removes all the formulas and simply pastes values in the rows and columns in Excel. Once you have it pasted as values you can delete whatever you want.
Retrieving data ...