0.0px

  1. A

    Excel & Outlook for Mac - Macro?

    hi all. I was initially trying to create a macro in outlook.. but outlook for mac doesn't support macros, so here we are back in excel, trying to integrate with Outlook.. I get about 25 'sales lead' emails daily, and i'm wanting the details to automatically create contacts in my outlook. I can...
  2. W

    Help with ISNUMBER

    I have a spreadsheet with a list of titles such as this one in A2 <colgroup><col></colgroup><tbody> CLT Referrals May 2017 I have a formula working on that cell: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color...
  3. S

    Add top level menu to Command Bar

    Hi Im pretty new to excel and have inherited a piece of code to allow me to add an item to the menubar. Issue is Im getting a "runtime error 9" when i step through the code. Despite looking online and on here and trying a number of tings I just dont know enough about VBA to fix this, so any...
  4. R

    iferror/sumifs

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #006107}span.s2 {color: #0057d6}span.s3 {color: #ab30d6}</style>=IFERROR(SUMIFS('1'!H:H,'1'!D:D,Stage!B9),IFERROR(SUMIFS('2'!H:H,'2'!D:D,Stage!B9),)) Hi all! Thanks in advance for any...
  5. P

    Bypass ‘multiple row context’ in DAX computation for Excel Pivot Table

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'American Typewriter'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'American Typewriter'; min-height: 14.0px}span.s1 {text-decoration: underline}span.Apple-tab-span {white-space:pre}</style>My original relational...
  6. B

    Repeating a Macro on Different Cells

    I'm a newbie and have never used macros before. I would like to have the following code repeat until row 245 if anyone can help. Thanks in advance <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo...

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