anymore

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

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!

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

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

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

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

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

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

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

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

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

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

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

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

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

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!

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