successfully

  1. M

    Trying to Power Query to a folder on my desktop, getting an error that "external component has thrown an exception"

    Need to figure out a fix but have no clue how to do so. I've used this successfully before, really need it to work. Any help is appreciated!
  2. J

    VBA: right of a character and include that character

    Hello, small problem: Right(elem.innerText, Len(elem.innerText) - InStrRev(elem.innerText, " / ")) This successfully pulls right of the "/". How would I adapt to include the "/" as well? Thanks.
  3. R

    is it possible to just enter time and have the format in HH:MM?

    I would like to just enter "1400" and have it format to "14:00" if possible. I also have a VBA code that automatically re-formats cells to the correct formatting, would this be able to also successfully convert 1400 to 14:00 for instance?
  4. D

    Code for ascending dates

    I have a worksheet that copies to another sheet successfully but I want to add in the code for it to sort the dates in column A so it is in ascending order. The code I am using to sort that column gives me this error https://www.screencast.com/t/PfhLFOtFxR7 and the code is...
  5. J

    Countif & Indirect formula

    Hi, so i'm trying to work out a formula but i'm stumped because I don't really know what it does! Basically, I have an old worksheet which successfully uses this formula pointing to a sheet called "Caravaggio"...
  6. M

    Recalculation Not Working

    I have a file I have used successfully for 3 or 4 years. I am using Excel 2016. Now all or a sudden some formulas don't seem to recalc successfully. The suspect formulas are verifying that the sum of a lot of SUMIFS() formulas equals the total of the data that is being extracted selectively...
  7. Nelson78

    VBA: delete duplicates in a range except for the first one

    Hello everybody. I have a situation like this: https://imgur.com/a/1MTsnEQ I need, for the range B2:R2, to delete all the value "closed" except for the first. My attempt is not concluded successfully (I can count the occurrences, but not delete). Dim rng As Range Dim q As Integer Set rng...
  8. K

    Stop aging when status changes

    Hi! I am seeking for a help on how to stop aging when status changes Assumption: A32 - DATE ACQUIRED G32 - AGING (# of days) I32 - STATUS (with drop down: Successfully Closed On Hold Inactive...
  9. M

    .PivotItems("(blank)").Visible = False, Not Working

    Hi there, I cannot successfully filter out (blank) in a Pivot Field. Has anyone experienced this before? It's working several times in my macro, but fails on a particular field "Receiver". Checked spelling, it all looks fine, even filtered N/A successfully. Any help would be much...
  10. R

    Is there a bug in custom region in excel 2016

    After successfully import KML/shapefiles into Power Map Excel 2016 via "custom region", those ploygons do not show up on the map at all. Note that those KML/Shapfiles are fine and can be successfully displayed in other GIS softwares. Does someone have 2013 and power map who maight want to try...
  11. N

    I want to open 70 excel files, but I get "out of memory" error in the middle

    hello excelers, those 70 excel files are heavy files, I successfully open 21 excel files, but on the 22 file - it won't open, just give an error with headline "Microsoft visual basic for application" and says "out of memory", which is logic, I've seen I can really work on those 21 files...

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