Multiple if statements in a for loop

**clauz_vi67** · 04-18-2019, 08:26 PM

Hi

I've tried different methods to include multiple if statements in a for loop but they don't seem to work and I'm not sure what the problem is. I keep getting the message "End If without block If" I have a different condition for each of the statements. Can someone help me please

For Z = 4 To lastrowG
If WorksheetFunction.isblank(data.Cells(Z, 147)) Then data.Cells(Z, 148).clearcontent

ElseIf data.Cells(Z, 154) = "F" Or data.Cells(Z, 154) = "FI" Or data.Cells(Z, 154) = "TC" Then data.Cells(Z, 148).clearcontent

ElseIf data.Cells(Z, 147) = "Duplicate" Then data.Cells(Z, 148).clearcontent

ElseIf data.Cells(Z, 148) = "Yes" And WorksheetFunction.isblank(data.Cells(Z, 159)) Then data.Cells(Z, 159) = "NA"

End If
Next Z

**Greg M** · 04-18-2019, 09:16 PM

Hi there,

If by "they don't seem to work" you mean that a Syntax Error message is generated then try:

Please Login or Register  to view this content.

The worksheet function "IsBlank" doesn't seem to be available in VBA.

I'm assuming that your workbook contains a worksheet whose CodeName (not Tab name) is "data"

Hope this helps.

Regards,

Greg M

**clauz_vi67** · 04-18-2019, 09:22 PM

Hi

I keep getting the message End If without block If

**Greg M** · 04-19-2019, 09:34 AM

Hi again,

Ok on that, but in order to make a further suggestion I would need to see the entire routine rather than just the code snippet you posted.

Regards,

Greg M

Multiple if statements in a for loop

LinkBack

Thread Tools

Rate This Thread

Display

Multiple if statements in a for loop

Re: Multiple if statements in a for loop

Re: Multiple if statements in a for loop

Re: Multiple if statements in a for loop

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Multiple If statements with multiple then statements pulling from Index/Match commands

imbedded if statements in a for loop

Loop with two statements

[SOLVED] For loop with mulitple if statements.

Multiple If statements inside a for loop error

Nested IF statements or CHOOSE statements needed for multiple conditions formula

VBA Do...Loop Statements

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions