maximum range

  1. S

    VBA to set maximum scale on chart secondary scale only

    So I tried to research this online and found loads of vba to set all the settings and thought my cut down version below would work, and it didn't! I keep getting a system error &H80070057 (-2147024809) Sub ScaleAxes() Worksheets("PM and Programme view").Select...
  2. E

    created table of Refs and lookup maximum for repeated references.

    Hi everyone. I've been having a few serious problems with excel and given I'm rather new to it all I'm really unsure how to figure things out. I've been searching the internet for a way to solve my problem and everything I have tried hasn't worked. I'm unsure which combination of match...
  3. M

    Maximum range for sum() function?

    I am trying to sum 44,582 cells in a column, the values in all of them are either 0 or 1, but I always get a value of 0. It works when I bring this right down to 1000 or 1500 cells but it can't seem to sum the entire range. This is Excel 2004 for Mac OSX Version 11.3.5 Any help appreciated...

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