longer

  1. H

    Macro no longer works after adding worksheets to workbook

    For some reason, I get an error message after I add a new worksheet to my workbook. It says "cannot run the macro. The macro may not be available in this workbook or all macros may be disabled" My macro security settings are correct. Any ideas? This is the macro: Sub createNewWorkbook()...
  2. F

    Step through a Macro

    I just bought the latest version of Excel and I use to be able to step through my macros with F8. It no longer works. Also My control buttons don't work. Has it changed?
  3. L

    Is this conditional formatting or something else?

    Hey all, There’s something I was wanting to do with our QC checklist, and I’d like your help with it. Essentially the idea is to have the cells conditionally formatted so that If cell J15= Y the all the cells to the right (M15,V15,AE15,AJ15,AM15 and AP15) will have a red fill until it is no...
  4. T

    Excel features no longer working

    I am creating a budget template. I am sharing it with two others but they haven't added any restrictions. For some reason, I can no longer click certain features in Excel (such as add border or font color). The workbook does have a macro which locks each of the three tabs when the file is opened...
  5. M

    vlookup woes

    Good Morning So I have two sheets. both have Zip codes but on one sheet some of them are 00000,some are 00000000 and some are 00000-000. the other sheet are all 5 position 00000. for them to match I'm using =LEFT(A1,5) and it shortens them all to 5 positions but then Vlookup no longer works...
  6. C

    Protection - One time usage only in Office 365

    When I protect/unprotect cells and then protect the worksheet I allow users to Sort / AutoFilter / Insert Rows. They are only able to perform these functions once and then that ability is removed and they can no longer perform those functions. Is there a way to override this and always allow...
  7. T

    Excel "helper" no longer appearing

    Hello The helper or guide for excel no longer appears. For instance in the past I would be typing code and a "helper" would pop up. In a module, If I entered Columns. a drop down box with all the available choices would appear. Or if I entered Columns.Find( the properties needed for each comma...
  8. M

    VBA Userform Name

    I am working on a project where I have numerous userforms and each as a date that auto-populates in a text box, well it used to populate. I name the userform a custom name, but when I double-click the userform to view the code, it no longer uses the custom name, but rather defaults back to...
  9. piannetta

    Adding only the latest data to existing table

    Hi, I am relatively new to Power Query in Excel, I am really enjoying it though and can't believe I didn't pick up on years ago. Anyway, that aside, I've built a number of spreadsheets with a number of queries within each that automate a lot of my reporting and tracking activities. The queries...
  10. J

    Formula longer than 8192 characters. Identify cell?

    Receive an error: "One or more formulas in this workbook are longer than allowed limit of 8192 characters. To avoid this limitation, save the workbook in excel binary workbook format." Workbook contains thousands of used cells. How can I identify the cell that is longer than 8192 characters...
  11. Burrgogi

    Running totals with SUMIFS formula - no longer working

    I created an excel sheet that contains all the purchases we've made at Costco. The main thing I was interested in was calculating the total grocery expenditures for each month in 2018. The SUMIFS formula that I had for some reason is no longer working. For reference, I posted a question about...
  12. W

    Conditional Formatting

    I haven’t used excel in years. How do I format a cell to be red when the cell is blank. Once something is entered into the cell, the cell is no longer red. Please and thank you.
  13. A

    Killing Excel hidden behaviour

    I'm attempting to enter data by hand into a worksheet. I have selected cells and formatted it to text only. When entering -7.82 dB it adds = and some other nonsense ahead of what I have typed. And I can't remove it. Attempting to has highlighted a Cell blue and Hung me on something as R-click...
  14. V

    Max If Criteria 2 separate columns.

    Hello Guys I have a formula here. Array Formula Needs to be Entered by CSV. =Max(if(A:A=G2,C:D)) There's nothing wrong with the formula above. It's working perfectly fine. However , I notice that if the column is separated. It will no longer work. Let's say the results I want a max...
  15. W

    Run MAcro if Excel is left unattended

    So I would like to automaticaaly protect a worksheet if the user is no longer inputg data after 10 seconds. Can this be done?
  16. I

    Clear value once active cell is then not active

    Morning, Can you be of assistance to alter the following code supplied. I wish to clear contents of the active cell B13 once its no longer the active cell. Have a nice day. ​Sub sbClearCellOnlyData() Range("B13").ClearContents End Sub​
  17. F

    Macro - enter row once data does not match

    Hi all, Is there a way that I can make a macro to enter a row once 2 cells no longer match? Let's say there is data in columns "A" to "Z". Once the data no longer matches in Column "L", I would like a row added in between. Thank you!
  18. K

    F4 no longer repeats last action

    Hi Everyone, This is driving me a bit crazy. It used to be that Excel would repeat the last action I made if I pressed the F4 key. Now it no longer does this. It's not an issue with a function lock. If I press F5 I still get the Go To menu. But somehow F4 no longer repeats the last action...
  19. K

    VBA: Automatically Hide/Unhide Rows Based on Cell Values

    I am attempting to make it so rows hide/unhide based on the values in Cells C6, C12, and C14. I wrote the code for it and had it working, but for some reason after coming back to it a few days later it no longer works. The code is as follows: Private Sub WorkSheet_Change(ByVal target As Range)...
  20. paquirl

    Embedded code to auto re-size columns no longer working in win10/excel2016

    I had this embedded code in a worksheet to auto re-size columns. When I upgraded to win10/excel2016 it no longer works. Please help! Option Explicit Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Application.ScreenUpdating = False...

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