If statement inside a loop

[jeskit]

Hi

Does anyone know how to create an if statement which has two variables?

I need to create an if statement which will go inside a loop that loops through a cell range which first checks if it is empty and if its not then i need to to say if the value in the cell on row 1 of the corresponding column = "12 months" and the value in the cell in column E of the corresponding row contains "Per Unit then place "12 month per unit" into the cell in sheet variable PPCWBSht in the 4th column.

I had a go at the writing the code myself however i get an error saying "Subscript out of range" and it highlights the row i have coloured red in the code below.

Please Login or Register  to view this content.

Next cellDoes anyone know how to do this?

Thanks

Jeskit

[Roger Govier]

Hi

Post an example of your data so we can see what you are trying to do.

[royUK]

Looks like AutoFilter might be a better option or use SpecialCells