Aidan,

Thanks for the assistance. When I make the named range dynamic though,
it is just selecting a huge range, not what I am looking for. I want
to select 2 columns and right now 30 rows starting at G5... so G5:H35
(that's how the range is defined now). I will want the rnage to be
defined from G5 until G has no values in it. i.e. the named range will
stop if the column G and row X is null.

Thanks,

Rob