Set a Range variable

[Gabor]

Hi,
Having trouble to find out what's wrong with this one:

Please Login or Register  to view this content.

I get: it is an application-defined or object-defined error.
Thanks for any hint.

[royUK]

The answer is in your thread Title. You don't use Set, which you must with Range variables

[royUK]

I've had a closer look at your code & you could have problems with the Range declarations, you don't define which sheet Rows.Count refers to in the way you have written the code, that's why I generally use a With Statement Yor destination range is wrongly defined as well

Please Login or Register  to view this content.

This might be better

Please Login or Register  to view this content.

[Gabor]

Yep, got it.
Works fine.
Thanks a lot.

[snb]

the same result:

Please Login or Register  to view this content.

[Gabor]

A beauty.
Thanks.