Select non-adjacent cells in a Range in Excel

[donishere]

How do I select non-adjacent cells in Excel? Do I use the Range function?

thanks,
don

 

[DaleWatson123321]

Hi Don,

This should do it...

Sub Selection_Disjointed_Cells()
Range("a1:a10,G21:G24,D2023&quot.Select
Selection.Name = "test"
End Sub

The last row assigns the range name "test" to all these disjointed ranges. Then you can more easily reference this collection of ranges by just the one name.

If you can also reference the individual ranges by a Range Name, then you should also do so - i.e. assign the range names beforehand. Anytime one can eliminate "hard-coding" it's naturally preferable.

Hope this helps.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca