Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to have a loop that finds empty cells in a range. For those empty
cells, I want an equation to be filled in. However, with the following program, it won't recognize that any of the cells are blank...even if they are in fact empty. What am I doing wrong? Dim Last_Cell, First_Cell as Range -- 'code to declare what Last_Cell is -- For Each First_Cell In Last_Cell If Last_Cell Is Nothing Then First_Cell.Formula = "=dsum(H15:M2000,m15,ak5:al6)" End If Next First_Cell Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Do Until empty loop | Excel Programming | |||
Loop through worksheets & empty cells based on color | Excel Programming | |||
Loop until cell is empty | Excel Programming | |||
macro to colour empty cells (cells not recognized as empty) | Excel Programming | |||
Empty cells in For Loop | Excel Programming |