issue

Good day. I am running Excel 2013 on Windows 10 Home. I have a workbook containing 7 worksheets. One of the worksheets uses LOOKUP to access a number from one of the other worksheets for each entry on the first worksheet. After entering new data in Row 95 of the worksheet, the LOOKUP...

Hi all, My VBA used to run with no issue, but recently seeing "System Error &H80070057 (-2147024809)" VBA simply protect all worksheets in the workbook. Am currently using Office 365 (running under Win10) . Any clue what could have caused the issue? many thanks...

So I have thousands of rows of data every day. In column F I have an event code and in column G I have the duration of that event. I need to know if "Event B" occurs within 20 minutes of "Event A". If F2 is "Event A" and G2 is 0:09:23 and F3 is "Event X" and G3 is 0:00:03 and F4 is "Event Y"...

We have an issue with the excel where there is noticeable alow down in the newer version of office.When getting an excel handle create dispatch and open api of Microsoft office takes more time in office 2016 then in office 2013.Pls guide me with the possible solution or reason for thjs slowness.

Hi, I'm sure this is a silly one but I can't figure it out. I'm wanting to add the following formula using my macro: =IF(OR(C8>=6,D8>=6),"Strength","") When I convert that into my script it looks like this: Cells(r, 6).Formula = ("=IF(OR(" & Cells(r, 3).Address & ">=6," & Cells(r, 4).Address...

So I have a small issue with reading and greatly need help with a problem I am having and trying to get it to proof on my College homework. I get the actual math behind it but trying to get the right formulas in Excel to work has been a major issue. So the problem goes like this. You are...

Hi, I've applied similar logic to two other macros but for some reason I am unable to figure out what I'm doing wrong :crash: Sub sfortest()Sheets("Cleanup").Select Range("M2").Select Dim Lastrow As Long Lastrow = Range("L" & Rows.Count).End(xlUp).Row Dim strFormulas(1 To...

So I am currently working on a sheet into which I would like to place this formula into cell Q6. =ROUND(SUMIFS($P$6:$P$97,$H$6:$H$97,$H6),2)=0 what I am trying to figure out, is how do write this in vba so that it enters the formula in all the column q for every row. So the issue is that the...

Hi Guys. I have an issue in this file. I have a Sheet 2 with formula references in another Sheet 1. The issue is related with deleting rows in sheet 1, because in sheet 2, in the other cells, on the right side of the formula references, there are written informations. Practically when I delete...

Hi Guys, I have an issue with duplicates match formula, the issue is this: [/URL][/IMG] Pescara is wrong. I would like to have a formula that can choose the second one, so Chieti. The actual formula is very simple, it is: =INDEX(B2:B11;MATCH(G2;C2:C11;0)) (in order to find Pescara) but this...

Hello there, I have an extensive custom excel add-in which engages in all sorts of macros when opening certain files (tests are done on workbook open before performing any of the macros) and the add-in includes a custom ribbon. Until recently this add-in has only been used on windows, but I've...

Hi guys, I have an Issue with a formula. I have to put the data in order. The formula in cell F2 is LARGE(C2:C8;1), from cells F3 to F7 is the array in the picture. The array is ok, the issue is that is not working exactly as I want. The issue is underline in the picture, I want to repeat...

Hi all. Firstly, as always, a much big thank you for all the help provided in the past and currently. This is much appreciated. Secondly, another issue. This issue being I have a textbox for customer phone. I need to format this to only allow 11 digits, no more, no less, it can't use...

Hi, I have 4 values of amounts , 2 values are positive and remain two are negative. value of positive and negative amounts are same (below table). when i have sum all of these 4 value then the result should be 0 but there is some other value is coming out. Please help me to coming out from...

I'm looking for help in creating a macro that can extract select column information and create new rows data but still keep the identifying information. Not all columns will have information and I only want to extract those that have data. Below is an example of the survey data...

Dear All, my friend came across a very strange formula, when you imput in any cell=-" :", you get a number:416.666, anyone can tell me why? hope some one can solve my issue. best regards! calvin

Sorry if this is in the wrong location, this is the first time I am posting on this forum. My issue is a regarding a "Compile Error: Method or data member not found" that happens when an excel file is opened by some users. These users have either excel 2013 or 2016 installed. The compile error...

Hi all, I am having an issue with my copy paste code. Here is my code: If Range("B49").Value = "Other" Then Sheets("Sheet1").Range("B50").Copy Sheets("Sheet2").Activate lastrow = Range("D65536").End(xlUp).Row Cells(lastrow + 1...

I'm having an issue and I think part of it is I'm probably overthinking the issue. I have an output report that provides me with some folder sizes. It came out in megabytes. As I'm presenting this to upper management, I need it in a format they understand; gigabytes. How can I take column "C"...

Hello, I have a spreadsheet that's giving me a very strange issue. Sometimes when I paste special values, or change a number being used in a calculation, I get a partial overlay from a different tab on top of my current tab. Here is a screenshot showing the issue: https://imgur.com/a/YG1mfUF...