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

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.

In article ,
"Greg B..." wrote:

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

Ok I see what you mean.

Thanks it is working now I unmerged the cells

Thanks Greg