jeudi 16 juin 2016

Check whether cell contains certain values VBA Excel

I'm trying to cycle though the rows of a sheet and check whether the first cell in the row contains a certain value. The first column is in date format mmm-yy as follows:

enter image description here

Basically I only want to look at the data in the row if the month is either May or June, so my if clause has to be on the condition of finding the substring "01/05" or "01/06". I'm sure this is a simple solution but so far all of the syntax I have tried throws an error. Can anyone help with this please, what should the if statement look like?

Aucun commentaire:

Enregistrer un commentaire