Hi, as per my other thread the other day about plottin in Excel I have a quick question that should probably seem pretty straight forward to someone a little more pracitsed than I am in VB.
When plotting a chart in Excel, you highlight the column(s) and click chart, the values you select always go on the y axis and you have to select your own values for the x axis in the chart menu, the code looks like this:
that last part, "=Sheet1!R7C7:R27C7" is the part I will have to create to be able to plot the entire graph in one macro, does anyone know a function I can use to generate the R7C7:R27C7 from just entering a range of cells, i.e. that code comes from G7 to G27, Row 7, Column 7 etc.
Is there a function you can just take the letter from and from that generate the number of the letter in the alphabet? I.e. G is the 7th letter, also I'd have to ignore the letters at the start of the cell address, so if its A1 or ZK139, you'd have to bypass any characters.
I'm not askin someone to do it for me, just mention a function I can find out for myself, thanks.
When plotting a chart in Excel, you highlight the column(s) and click chart, the values you select always go on the y axis and you have to select your own values for the x axis in the chart menu, the code looks like this:
Code:
ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R7C7:R27C7"
that last part, "=Sheet1!R7C7:R27C7" is the part I will have to create to be able to plot the entire graph in one macro, does anyone know a function I can use to generate the R7C7:R27C7 from just entering a range of cells, i.e. that code comes from G7 to G27, Row 7, Column 7 etc.
Is there a function you can just take the letter from and from that generate the number of the letter in the alphabet? I.e. G is the 7th letter, also I'd have to ignore the letters at the start of the cell address, so if its A1 or ZK139, you'd have to bypass any characters.
I'm not askin someone to do it for me, just mention a function I can find out for myself, thanks.