What is the intialized value for a cell with general format?
 

I am attempting to value one cell in a workbook based on whether there is a
value in another cell. I have tried to check for zeros and spaces and
neither seems to work. The format of the cell that I am checking is general.

What is the intialized value for a cell with general format?
 

Hi
what do you mean with 'to value one cell'?

--
Regards
Frank Kabel
Frankfurt, Germany

"Edith F" <Edith schrieb im Newsbeitrag
...
I am attempting to value one cell in a workbook based on whether
there is a
value in another cell. I have tried to check for zeros and spaces
and
neither seems to work. The format of the cell that I am checking is
general.

What is the intialized value for a cell with general format?
 

The inital value of a cell is blank. In code you can check to see if the
value is equal to "" or in the sheet you can use the IsBlank function.

"Edith F" wrote:

I am attempting to value one cell in a workbook based on whether there is a
value in another cell. I have tried to check for zeros and spaces and
neither seems to work. The format of the cell that I am checking is general.

What is the intialized value for a cell with general format?
 

Got my answer, thanks for answering my post

"Frank Kabel" wrote:

Hi
what do you mean with 'to value one cell'?

--
Regards
Frank Kabel
Frankfurt, Germany

"Edith F" <Edith schrieb im Newsbeitrag
...
I am attempting to value one cell in a workbook based on whether
there is a
value in another cell. I have tried to check for zeros and spaces
and
neither seems to work. The format of the cell that I am checking is
general.

What is the intialized value for a cell with general format?
 

The Isblank worked, thanks so much

" wrote:

The inital value of a cell is blank. In code you can check to see if the
value is equal to "" or in the sheet you can use the IsBlank function.

"Edith F" wrote:

I am attempting to value one cell in a workbook based on whether there is a
value in another cell. I have tried to check for zeros and spaces and
neither seems to work. The format of the cell that I am checking is general.