objcht

  1. T

    Help with Assigning Cell Value as Variable

    In the code below, why do I keep getting an Object required error? It happens on the Set CellChange below. Isn't my syntax correct? Option Explicit Sub Worksheet_Calculcate() Dim objCht As ChartObject Dim CellChange As Long Set CellChange = Sheets("Price Bridge Chart").Range(2...
  2. T

    Code to Change Y-Axis not firing anymore Excel VBA

    My code for changing the Y-Axis was working perfectly yesterday yet does nothing today. It monitors the minimum and max values in static cells and changes the scale based on the code below. I know the change event is the correct one as it was working yesterday. Could I ensure that it always runs...
  3. P

    Need to specify chart for rescaling as opposed to All charts in worksheet.

    I use the following routine to scale a chart the way I want to display it The routine that I "borrowed" however operates on all chart objects in the worksheet. How do I change the code to only operate on "Chart 6" but leave other charts untouched. Thanks in advance. Sub Format_charts()...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top