When no recordset found then display 0 in the cell.

Hi All

The below code works fine except when there is no recorset found then i want to display 0 in the cell but its not doing it. The code just leaves it blank if no recordset found.

Can anyone please help me in this?

Please Login or Register  to view this content.

Hi
Do you have "display zero values" switched on in your Excel Options?
Tony

How to check that whether the "Display zero values" are switched on or not??? Thanks

Hi

Display or hide all zero values on a worksheet
1.On the Tools menu, click Options, and then click the View tab.
2.Do one of the following:
To display zero (0) values in cells, select the Zero values check box.
To display zero values as blank cells, clear the check box.
Good luck.
Tony