Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba check cell value
Say the possible zeros are in column A:
Sub StayHappy() Dim n As Long Dim i As Long n = Cells(Rows.Count, "A").End(xlUp).Row For i = n To 1 Step -1 If Cells(i, "A").Value = 0 Then Rows(i).Delete End If Next End Sub -- Gary''s Student - gsnu200848 "Neil" wrote: 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 |