Check for empty cell in a range of #N/A cells

[Ramo13541]

Hi everybody,

I'm looking for a macro to find the row (in twho columns) that contains one of the two criteria: "" or "Productivité".
After finding the first row that contains on of these cells, i'm trying a loop to move down this row. if the next down cell does'nt contain neither "" or "productivité i have to resize my range to add one row to it.

that is the problem. When i'm testing `Do While Not Range(strDépartPlage).Value Is Nothing And Range(strDépartPlage).Offset(, -1).Value <> "productivité"` it's not working because of the first condition `Do While Not Range(strDépartPlage).Value Is Nothing ` . And it's due to the fact that the cells contains `#N/A`. How can i deal with that ?

Please Login or Register  to view this content.

[InvisibleMan]

Please Login or Register  to view this content.

[Ramo13541]

Hi InvisibleMan,
It doesn't work neither:

Please Login or Register  to view this content.

[Ramo13541]

Actually, In other words, I'm trying to extract the range's address between the blank cell and the cell next to the one that contains "Productivité", and the range's address between the cells next to ones that contain "Productivité".

[InvisibleMan]

Suggest you post a sample workbook.

[Ramo13541]

hi invisible man. it doesn't work when i try to add my file