View Single Post
  #10   Report Post  
Old August 30th 19, 08:59 PM posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,763
Default IF function + NBCAR

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!AqMiGBK2qniTgeV9...sVDLg?e=QJRpUh
When you open it on your system, the formulas should be translated to

Claus B.
Office 2016