issues

  1. F

    Userforms and memory issues

    Good morning. Ive been creating a couple of userforms and I notice that when I test all functions and changes I make I keep getting this error "out of memory" in my excel . I think the userforms are the issue. Typically during testing , the userforms are loaded and unloaded a ton of times...
  2. A

    Compare date and count if meets specific criteria

    Hello All, Ive been trying a few things in other threads, but just cant seem to get this working. I have specific conditions that need to be counted per month. <tbody> ID Reason Timing Date <tbody> CRQ145074 </tbody> <tbody> Successful </tbody> <tbody> Standard </tbody>...
  3. J

    Proof of Concept

    Hi All i have a project that is outside of my current skill set. I'm not asking for someone to do it for me. sorry if this makes no sense. just want to make sure 1. if my idea is even viable 2. suggestions on possible area's issues may arise. 3. am i using the correct terminology. 4. people to...
  4. J

    Prevent saving of custom view and sort information?

    Hope this makes sense. I have a co-authored spreadsheet that we're having save issues with. When one user is working all is fine, but when we get multiple users there are "Unable to Save" errors. The spreadsheet has custom views set up for each user (that hide columns), as well as custom...
  5. P

    Place category on right side base on left two numbers

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, I would like to write a vba, so that where in col. “D” the first two numbers on the left are like below, should place the relevant category on the right. The 1st schedule...
  6. P

    Site Issues

    Hello all. I was wondering if anyone else was having issues navigating the forum this morning Screenshot by Lightshot Thank you
  7. Z

    Excel randomly crashes and stops working when using data validation dropdown list

    Dear All, I'm having issues with Excel randomly crashes and stops working. When I click the cells with data validation dropdown list in some Excel files, Excel randomly stops working and crashes. I cannot reproduce the issue. Sometimes restart computer makes it better, but it gets worse again...
  8. I

    VBA Code issues - Cannot get file to save as using cell contents

    Hi guys, I'm pretty new to VBA. I know there are some similar threads on here which have similar issues, I've worked my way through them and I'm still at a loss as to why my code won't work. I'm trying to create a button which will save the workbook to a certain location using the contents of...
  9. W

    Object required?!?!

    Excel keeps saying there is an error with startd = wb1.Sheets("Master List").Range(i, 10) anyway i change it (taking away set, changing the dim of startd, doesnt seem to work) Please help. (i am aware that there is probably a few other issues with this that i havent come across.....macros...
  10. S

    Min IF Errors

    I was wondering if you could help. I am trying to use Min If to return the lowest date that we invoiced a client. we have thousands of rows of invoices and i am using the IF function to match the client name and site before it returns the earliest date. The formula i am using is ...

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