IF function in a macro?

[Luccin]

Dear all,

I have an issue with a Macro. What I would like to do is:

- select certain sheets according to a fixed criteria (e.g. sheets 1,2,3 if ARB is displayed in Sheet 1, Cell D8; sheets 1,5,7 if AWB is displayed in Sheet 1, Cell D8; etc.)
- copy the selected sheets in another Excel file, which will automatically open
- have the file save itself automatically on the user's Desktop with a specific name

So far, I managed to do parts 2 & 3, but I am struggling with part 1. Here is the code i used:

Please Login or Register  to view this content.

Thank you all for your help. It is much appreciated!!!

Best regards from Bangkok,

Luccin

[royUK]

Do you want to add them to the array?

[t0m46]

Hey,

The IF statement will be something like this

Please Login or Register  to view this content.

Is this what your after?

[Luccin]

Thanks for your help! I finally managed to get what I was looking for.

Best regards,

Luccin