Thread: Isblank Code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Isblank Code

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