Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Boolean to advance loop
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Boolean to advance loop
For Each cell In sh.UsedRange
If IgnoreBlanksBttn = True And Application.WorkbookFunction.Isblank(cell) = True Then 'New ' do nothing Else Call MainAudit(ChkbxCtrlFind) End If 'New Next -- HTH RP (remove nothere from the email address if mailing direct) "ExcelMonkey" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |