I'm pretty new to VBA, and I'm trying to program a graphing macro that allows the user to select and graph a portion of CSV-exported data.

An example of the spreadsheet data is:

....A...................B....................................C........................D.................E......................F
1 Facility ID....Facility Description..Facility ph #.....Day1Data....Day2Data.....Day3Data
2 5647............NW Plant.....................555-5555..........12...............20...................22
3 9994............NE Plant.......................555-5556..........25...............31...................29


I want the user to select a few facility IDs from Column A, and then have the macro create a line graph of columns D, E, F corresponding to the facilities that they've selected.
e.g., user selects A5:A8, and the macro creates a graph of D5:F8.

MY PROBLEM:
The way I've coded the macro (my code is below), it only works properly when the user selects a continuous range of cells. I want it to work when the user selects a non-continuous range, as well.

How would I go about doing this?

Please Login or Register  to view this content.