anymore

  1. L

    when filter function will be available?

    Hi I just watched a video and ExcelIsFun author said Filter() not not available now. He manged to do a lot of stuff without using array function anymore. That is a big change. My second question, is Microsoft going to get rid of array formula? https://www.youtube.com/watch?v=cB6UlIwpwVc
  2. M

    How to retrieve the date given the first non zero amount

    Hi all, I got below table where I want to extract the first date in the top row under the condition that the green row is not equal to zero anymore. Which formula would you advise to use? Thanks!
  3. E

    Lost Macros

    Hi There, I'm a bit confused. I appear to have lost my macros. I have written multiple codes and have created icons at the top of my excel window. These all appear to work fine but when I open up visual basic I cant see them anymore. What have I done? and how do I correct it? Any help is much...
  4. S

    Stopping calcs

    Making me angry because I know how to do it and forgot- I have a string of numbers (basically finance) that are all in a row- and A2 is the year. Each year the auto calculate with formulas from various sheets and workbooks and I’d like to “freeze” a row so that it doesn’t calculate anymore when...
  5. M

    Excel 2016 freezes opening a specific file, excel online can open the file.

    Hi all, I have an excel file which could not be opened anymore from one day to next. The loading bar usually stops at ~80% and then excel freezes and is not responding anymore (according to task manager). CPU workload and memory usage are both below 15%, respectively. Using excel online, the...
  6. C

    VBA to copy cell C5 and paste value to D5 based on A5 cell not empty anymore

    hello I'm trying write a VBA to copy cell C5 and paste values to cell D5 if A5 cell not empty anymore thank you
  7. L

    keep tracking sheet1 - vba

    Hi I am adding/deleting/moving/copying sheets in one workbook. So the order of sheets get change, their names get change sometime, etc. I have all Control buttons in Sheet1. So right now I can refer to that sheet as Sheets(1) Sheets("sheet1") but lets say later on I changed the order of the...
  8. reneev

    Multiple If Statements (Between)

    I'm trying to make a formula that basically says if this number (4.57) is between B and C, then pull in A. Since there is more than 7 options, a regular IFTHAN statement won't work. I just can't think anymore and need help. <colgroup><col><col><col></colgroup><tbody> A B C 0 - 6 mo 0 0.5...
  9. Z

    Can not extend anymore =Sumifs in macro anymore any help ?

    Hi I have below many more of these I added to this, but it wont let me add anymore +SUMIFS. I tried to go to second line using , _ but nothing. How can I keep adding if I need to go to second line rather then keep going across ? FormulaR1C1 =...
  10. A

    Formatting TextBoxes in Userform

    Hi there, I would like to format a textbox in my userform, so that only the correct format can be inputted. I would like the format to be the following dd/mm/yyyy 00:00:00 so the user has to enter both the date and time otherwise the box will error. Could anymore please show me the code to do...
  11. S

    Should be easy.. do you know it?

    Dear community, I've been struggling for two weeks now and i can't figure it out. countless attempts of trying brought me here so I hope some of you experts are able, and willingly to help me out. This is what I'm looking for: Whenever the IP addres is changes, i need the webquery output...
  12. S

    Web query

    Dear community, I've been struggling for two weeks now and i can't figure it out. countless attempts of trying brought me here so I hope some of you experts are able, and willingly to help me out. This is what I'm looking for: Whenever the IP addres is changes, i need the webquery output...
  13. Alice Morland

    How do we add a signature to our posts?

    Hi all, I've read the sticky post about signatures, buuuut the Signature bit doesn't seem to be in the Settings section anymore. Can anyone suggest how to add one, please? Thanks! Alice
  14. S

    Error message - "Can't find project or libarary"

    My workbook was working fine yesterday but today I keep getting the error message "Can't find project or libraray" - the box has a heading "Microsoft Visual Basic for Application" The file is quite large and has macros in it. I can't: 1. Save it anymore 2. Make changes before it says "not...
  15. 5

    Where did Workgroup go?

    I used to use the Workgroup feature when saving more than one workbook. This way all nominated workbooks would be grouped together when saving and would open together. However, I can't find Workgroup anymore. Is it still lurking in Excel? If so, how do I get to it? Thank you so much for your...
  16. C

    Macro that disables itself one executed? HELP please

    Hi, I would like to run a macro, and it disables itself when ran. here is code. Sub enterstopdown() Range("D6").Value = Now() End Sub so when they click this and it enters the date and time, I don't want that one to work anymore. Thanks!
  17. R

    Settings: Excel won't complete closing parenthesis anymore

    Hello, I think I accidentally changed an Excel setting. When I enter an incomplete formula (i.e. final parenthesis missing), it doesnt auto-complete anymore and jump to the next line, instead it gives a blinking highlight and stays in the same cell. https://imgur.com/VoO0Mac Hopefully...

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