I am trying to record a macro in Excel 2007 but I don't know squat about VB or how to debug.



I am making a digital version of an SPC chart. I am using a 'Line With Markers' chart to plot the data points.

I have a template spreadsheet with the chart made out and I want to use that to copy and rename for each different part number created. I want to make a macro to easily Format the Axis Options.

In my chart I am using:
BC1 for the Upper Size Limit (USL) of the part which is used for the Maximum.
BC2 for the Lower Size Limit (LSL) of the part which is used for the Minimum.
BG1 calculates the difference of BC1 & BC2.
BG2 divides BG1 by ten to get the Major Unit.
The Minor Unit is not used.

I am trying to make a macro that collects the data from BC1, BC2 & BG2 to enter it into the Maximum, Minimum & Major Unit text boxes (respectively). Can somebody please help me out.

Thanks,

PR

Look here for help on how to record a macro.

http://www.youtube.com/watch?v=kjAiyjsrXQY