Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to write a For Loop which runs all the populated cells in the
range through a calculation. My question is how do I make sure that empty or null cells aren't selected to be used in the calculation? Essentially I just want to ignore the empty/null cells. Below is the code for the loop in case this helps: For Each A In range1 For Each B In range1 If B.Value < A.Value Then If Abs(A - B) <= testvalue Then Sheets("Test Results").Select range("A1").Select Selection.End(xlDown).Select ActiveCell.Offset(1, 0).Select Selection.Value = "Interference" ActiveCell.Offset(0, 1).Select Selection.Value = A.Value ActiveCell.Offset(0, 1).Select Selection.Value = B.Value End If End If Next Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
When I SUM cells & 1 is empty I need the result to be empty not 0 | Excel Discussion (Misc queries) | |||
How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
Help - loop through cells in a range that are not together (several different cells as Target) | Excel Programming | |||
Can blank cells created using empty Double-Quotes not be empty?? | Excel Programming |