Set Range Application-Based Error

[aloha31]

I can't seem to figure out why I'm getting an object-based or application-based error for the following code:

Please Login or Register  to view this content.

The error appears on the "Set copydepartures" range declaration. Please help!

[HaHoBe]

Hi, aloha,

maybe try

Please Login or Register  to view this content.

Ciao,
Holger

[aloha31]

That fixed that issue, thank you. But now, I am receiving a "Mismatch" error for this line:

Please Login or Register  to view this content.

Each cell only contains a text string and cell is dimensioned as a range

[HaHoBe]

Hi, aloha31,

you would need to repeat cell.Value for each string, maybe itīs better to use a Select Case here:

Please Login or Register  to view this content.

Ciao,
Holger

[aloha31]

Worked perfectly. Thank you for your help.