Non-contiguous selection

  • Thread starter Thread starter PBezucha
  • Start date Start date
P

PBezucha

In the recent, cancelled question I asked Dave Peterson
how to select the range for later defining
SeriesCollection in the xy-chart:

With ActiveSheet
Set Rng1 = .Range(.Range(.Cells(1, 2), .Cells(N, 2)), _
.Range(.Cells(1, 6), .Cells(N, 6)))
End With

It really worked well as far as the columns were
contiguous. As soon as the columns were distant (as in the
example), all the area was selected, and a number of
excessive curves appeared. The problem is how to adapt the
range definition so that only two relevant columns are
taken.
Many thanks to any adviser.

Petr
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
Looping through Non contiguous cells in a row 11
To: Dave Peterson 2
Finding Smallest Date in Non Contiguous Range 3
How do I change the active cell in a non contiguous range or selection? 0
Clean this select case code up a bit. 2
Junp start my Select Case Macro 12

Back
Top