Selecting Two Named Ranges

[gsandy]

I have two named ranges, LV1 and LV2 and wish to select them for printing. If the ranges were fixed I would use - Range("A2:H4,A8:H10").Select - how do I do the equivalent using the named ranges in vba?

Thanks Sandy

[Leith Ross]

Hello gsandy,

Use the Union method to combine the separate ranges into one. Both named ranges must be on the same sheet and that sheet must be active. If not, an error will occur.

Please Login or Register  to view this content.

[gsandy]

I deleted the word "Range" and the quotation marks and it worked fine.
Thanks for your help. Sandy