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

[Guest]

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.

 

[Frank Kabel]

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

--
Regards
Frank Kabel
Frankfurt, Germany

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.

 

[Guest]

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.

 

[Guest]

Got my answer, thanks for answering my post

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

--
Regards
Frank Kabel
Frankfurt, Germany


general.

 

[Guest]

The Isblank worked, thanks so much

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.