I have a table with 3 columns.
First two columns contain data that would be used for charting. Third column takes a feedback from user in terms of Yes or No and then depending on their reply uses that row (first two columns of the row) as a part of the chart
for eg:
Device type No. Yes/No
abc 2
def 2 yes
ghi 6
jkl 600 yes
mno 40
pqr 400
Now since the user has selected 'def' and 'jkl' for charting, only those should be charted.
I have written following code
For i = 2 To 7 Step 1
If Range("c" & i).Value = "yes" Then
Range("a" & i & ":b" & i).Select
End If
Next
but the problem with above code is, it remembers only final selection i.e for 'jkl' and not for 'def' since 'jkl' was selected later. How do I have both ranges selected at a time?
Any inputs will be of great help
Bookmarks