save multiple range cells to a file

[elistein]

Hi Experts,

I would like to save multiple range cells to a file.

My code is working fine as long as the cells range are in the same column.

I tried to use the "Union" method but I got the "1004 error"

Attached here is my code

Thanks in advance

[xladept]

Hi elistein,

Try:

Please Login or Register  to view this content.

[elistein]

Hi xladept

Thank you for your fast reply.

Unfortunately the program still not working.

Still got the "run time error 1004" The command cannot be used on multiple selections"

All the best

elistein

[mike7952]

Give this a try

Please Login or Register  to view this content.

[xladept]

Hi elistein,

I didn't realize that it was choking on the copy - this worked for me:

Please Login or Register  to view this content.