formulas displaying

  1. B

    SpecialCells VBscript to get all Formulas fails w/Unable to get the specialCells property of the Range Class

    Trying to put a vbScript together that will go through an Excel Sheet and return all the Forumlas Found in the activeSheet. I am attempting to use SpecialCells to return the data. However, I get an error "Unable to get the SpecialCells property of the Range Class". Am I missing something to...
    • blpcrs
    • Thread
    • excel formulas displaying specialcells vbscript
    • Replies: 2
    • Forum: Excel Questions
  2. A

    How to calculate a specific percentage increase in Excel?

    Excel:Mac 2011 How do I structure a formula that displays a NUMBER (N) in the following scenario? 5000 + 68% = N i.e. Markup 5000 by 68% Thanks in advance!
  3. C

    Formulas showing R and C format

    All of a sudden my formulas look strange Sum(a1:b2) is usual now all my formulas look more like sum(C(-42)s:C(-1)s) I don't know how this happened, need urgent help to change back:confused:

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