Thanks w/ your and Tom's Idea I got it to work perfect using Union method. I
just saved myself several hours a month writing out lists by hand

"moon" wrote:


"Zb Kornecki" <zDOTkorneckiATcomcastDOTnet schreef in bericht
...
Hi I have a maro w/ a named range from which I need to select 2
Nonadjacent
rows based on variables but can't seem to get the code right. I need to
select row$1, col_x and row_y, col_x of named_rng_z.

any help w/ the syntax would be appriciated

Zb Kornecki



Checkout the 'Union'-method, Zb.

Dim r As Range
Set r = Application.Union( _
ActiveSheet.Range("A1:E1"), _
ActiveSheet.Range("A4:E4"))
r.Select