Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a for each loop which loops through cells in a
worksheet. I jsut added a line of code that says if the cell is blank, then don't continue on within loop and call main sub, instead advance to next cell in loop. I tried using the Next stmt but this is not working. How do you do this? For Each cell In sh.UsedRange If IgnoreBlanksBttn = True And Application.WorkbookFunction.Isblank(cell) = True Then 'New Next 'New End If 'New Call MainAudit(ChkbxCtrlFind) Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Boolean Math | Excel Worksheet Functions | |||
IF vs Boolean | Excel Discussion (Misc queries) | |||
More on Boolean | New Users to Excel | |||
VBA Boolean | Excel Discussion (Misc queries) | |||
Boolean Find | Excel Discussion (Misc queries) |