Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Why in this part of code in the first CEL have "FIL." and not the
first cell in filter???? In this case 4500 when SOMMA is =0 ???? (start Sub SPOSTA_LINEE_ZERO()) If SOMMA = 0 Then For Each CEL In RNG1 RIGA = CEL.Row If CEL = SPORTELLO And Range("D" & RIGA).Value = SOSPESO Then WS.Range("AA" & RIGA) = "ZERO" WS.Range("AA1") = WS.Range("AA1") + 1 End If Next CEL here the file: http://www.mytempdir.com/1247401 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting the correct reference cell to work | Excel Discussion (Misc queries) | |||
If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct? | Excel Programming | |||
I'm desperate I posted earlier about "If" statements that don't work but are correct. Now... | Excel Worksheet Functions | |||
I want to correct a #div/0! error but the IF function doesnt work | Excel Worksheet Functions | |||
Correct formulas in cells, have to retype to work | Excel Discussion (Misc queries) |