Hey MR. Excel Members,
I know the title sucks but let me explain as I think this is fairly easy but I cant manage to solve it.
I have a table that looks like this:
Now I want to loop through this table and set a range named "xvalues" to the B-column values for each platform (entry in column A) so that I can then put those values into a chart.
Basically the output should look something like this:
1st loop: Xvalues = Range("B18:B21") 'ChromeVersion76 values
2nd loop: Xvalues = Range("B22:B25") 'EdgeVersion 18 Values
...
4th loop: Xvalues = Range("B30:B33") 'Firefox69 Values
What Im trying so far is building sth like this but Im just very stuck:
As the table can vary in length and number of plattform-entries i wanted to somehow count how long each section is and then make the selection but cant get it to work. Im new to VBA and just very frustrated since hours.
ANY help on this would be greatly appreciated!!!
I know the title sucks but let me explain as I think this is fairly easy but I cant manage to solve it.
I have a table that looks like this:
Now I want to loop through this table and set a range named "xvalues" to the B-column values for each platform (entry in column A) so that I can then put those values into a chart.
Basically the output should look something like this:
1st loop: Xvalues = Range("B18:B21") 'ChromeVersion76 values
2nd loop: Xvalues = Range("B22:B25") 'EdgeVersion 18 Values
...
4th loop: Xvalues = Range("B30:B33") 'Firefox69 Values
What Im trying so far is building sth like this but Im just very stuck:
VBA Code:
Dim TableSection As Range
Set TableSection = FunctionToSetTableSection '(Sets TableSection to Range A18-A33)
TableSection.Rows.Count
RemoveDuplicates (RoteReiheRowValue)
Dim cell As Range
Dim EmptyCellCounter As Long
EmptyCellCounter = 1
Dim StartReihe As Long
Dim EndReihe As Long
For Each cell In TabellenAbschnitt
If cell.Value <> "" Then
Reihenzähler = Reihenzähler + 1
Else
As the table can vary in length and number of plattform-entries i wanted to somehow count how long each section is and then make the selection but cant get it to work. Im new to VBA and just very frustrated since hours.
ANY help on this would be greatly appreciated!!!