Macro to create chart using XLtoRight Variable for adding column data

I have a spreadsheet that is being updated frequently... Once data is added I have to manually re-graph the variable.... The code is as follows

Please Login or Register  to view this content.

Right now the graph only goes out to the Y column.. As time goes on - it's going to continue to grow X, AA, etc.... I was hoping to write a macro that would identify the LastColumn variable ala the XltoRight parameter ... But so for I can't get it to work (attempts aren't in the code)...

TIA
Jason

Hello my friend

Try this:

Please Login or Register  to view this content.

hmm never used the .CurrentRegion

Im trying it now - but to be honest I am a bit clueless

couldn't get it to work....

The previous things I tried were replacing

'ActiveChart.SeriesCollection(1).Values = "=MeFRRMaster!$B$9:$Y$9"

with both

ActiveChart.SeriesCollection(1).Values = "='MeFRRMaster'!$B$9:$Y$" & LastRow

or this

ActiveChart.SeriesCollection(1).Values = ("'MeFRRMaster'!$B$9:$Y$" & LastRow)

and neither worked.....


Ack

Ack... I am an idiot

ActiveChart.SeriesCollection(1).Values = "='MeFRRMaster'!$B$9:$Y$" & LastRow - wouldn't work .... I am looking for &B$9:$Y$9 - using "$B$9:$Y$" & LastRow" would give me b9 to y24 (or however many columns I had - which is just wrong... I need $B$9:$ChangingVariable$9