successfully

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!

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.

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?

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...

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"...

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...

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...

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...

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...

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...

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...