Hi Andrea,

Am Fri, 30 Aug 2019 20:26:59 +0100 schrieb Andrea P:

Unfortunately, I need those cells to be blank because I'm making an
macro that updates the sheet. When I press Ctrl+A, it usually only
selects the actual used range. But with the option to not show the
zeros, the cells are still filled so I have a very big range selected
which slows the macro down.

download the file from he
https://1drv.ms/x/s!AqMiGBK2qniTgeV9...sVDLg?e=QJRpUh
When you open it on your system, the formulas should be translated to
French.


Regards
Claus B.
--
Windows10
Office 2016