Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba check cell value
Hi
I have a work book with multiple worksheets. Sheet 1 used for data entry, data is entered in several rows and each row is then auto totalled. The totals are then pasted into sheet 2 where further calculations are applied. When the totals are passed to sheet 2 I get a column of figures which could contain zero values. I am trying to write a routine to scan the list and to remove zero value lines. Is there a VBA function which will allow me to check if a cell contains a zero value even though the cell contains a reference to a different worksheet? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check or uncheck a check box based on a cell value | Excel Discussion (Misc queries) | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
Cannot check the check mark box in cell | Excel Worksheet Functions | |||
check to see if a cell is blank if not populate adjacent cell wit. | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions |