Isblank Code

[Greg B...]

Hi again

I have a code where I want to put a isblank into the code

the code so far is


='FACE SHEET'!F19:U19

How do I put the isblank into this

Thanks in advance

Greg

 

[JE McGimpsey]

What are you trying to accomplish? Your formula right now, if
array-entered into a 1x16 cell range will return the values in 'FACE
SHEET'!F19:U19. If you instead array-enter

=ISBLANK('FACE SHEET'!F19:U19)

into a 1x16 cell range, you'll get 16 TRUE/FALSE values.

 

[Greg B...]

Ok I see what you mean.

Thanks it is working now I unmerged the cells

Thanks Greg