Multiple Variables in For Each Loop

Hi All,

I need to use two variables and have them always go to next, regardless of the outcome of the if statement in the code below. The problem is I need Next Cell and Next X to always be used after the If statement. I can only use Next Cell in this statement and then the if statement starts up again, but I need it go to Next cell then Next X then the If statement.

Any suggestions appreciated. Thanks.

Please Login or Register  to view this content.

Could you give a better representation on what you are trying to do within the workbook. There is probably a simpler way to do it. An example workbook might help.

I am taking the dept budgets from a range in a row.

Above the dept row name is the budget amount for each dept.

I am creating a temp sheet to paste all the dept names and amounts where the amount is not $0.

The Temp sheet will have two columns and look like the following:

Dept 123 $50,000
Dept 456 $75,000

I want Cell to be the temp sheet increment for ranges in the temp sheet.
I want X to be the dept budget increment for ranges in the dept budget sheet.

That solution worked great! Thanks HaHoBe!