Trouble making scatter plot loop

I am trying to make a macro that creates a series of scatter plots, based on criteria in column M. The data to be used for the plot are in columns G and H. Column M is sorted ascending, and for all instances of one value, the scatter plot is created. So while cells in column M = "x", select the top and bottom cell, storing each as a range, and then use them to create a range chartRange. I think my problem is in defining the chartRange variable, not sure though. here is the code so far:

Please Login or Register  to view this content.

I know that there are other problems with this code, but all I'm concerned with right now is properly storing and referring to that range.

I just realized my first problem, I had my offset values backwards. Now I am getting a "Object variable or with block variable not set" error for:

Please Login or Register  to view this content.