Non adjacent cells selection

[Ronanm]

Hi

Simple question which I've struggled with.. I want to select non adjacent cells e.g. A1 and C1.
I tried Range(Cells(1, 1), Cells(1, 3)).Select amongst other things but to no avail.

Thanks

 

[alansidman]

You might have better success with Application.Union function

https://docs.microsoft.com/en-us/office/vba/api/excel.application.union

 

[Ronanm]

Hi

Thank you, but I couldn't get it working using Cells instead of Range("A1: etc....

 

[Tetra201]

Try

Range("A1,C1").Select

 

[Ronanm]

Hi

It's really got to be using Cells. I.E. Along the lines of (Cells(1, 1), Cells(1, 3)).Select

Thanks

 

[Rick Rothstein]

It's really got to be using Cells. I.E. Along the lines of (Cells(1, 1), Cells(1, 3)).Select

Try it this way...

Union(Cells(1,1), Cells(1,3)).Select

 

[Ronanm]

Perfect. Thank you Rick