I am trying to plot a series within my vba code. The code below, which was tweeked from the recorder, works but my issue is that the source data is not always in columns A and B. X values are always in column A but the Y values can be in any column but is always to the far right in the sheet (i.e. last column used). How do I write the code to grab the Y values from the last used column?


Please Login or Register  to view this content.