Hi Berend,

Try:

Set rng = Range("A1:AK200,A250:AK400")


---
Regards,
Norman


"Berend Botje " wrote in
message ...
First of all, thanks for reacting.

Can I do the range thing with R1C1 coordinates? I can't get it to work
properly with multiple range selections. For example I want to select
columns 1 through AK of rows 1 through 200 and 250 through 400. How can
I do this?


---
Message posted from http://www.ExcelForum.com/