wrote

Greetings all, I am updating an estimating spreadsheet that I wrote probably 15 to 20 years ago. I wrote a macro back then that transferred information from the cost part of the sheet to the estimate sheet below, but it was in the old XLA format and I can no longer save it or make changes to...

How would you write a countif formula using a defined name range? My range...

Hello, ım new at vba, ı wrote a basic macro for my excel.This macro works like this: first he ask me how many company do you want to compare? exp: 3 and then ask wrote a company name and then it writes companies name to my main table and then ı see a value in some cell, so my problem is, there...

Am getting that compiler error on this very simple code: Sub app() finalrow = Cells(Rows, Count, 1).End(xlUp).Row For x = 1 To finalrow If Cells(x, 1) = 50 Then Cells(x, 1).Interior.ColorIndex = 3 End If Next x End Sub I wrote 10 numbers in column A including a "50" so it could turn red. I...

Wrote a long explanation and it didn't post, so simply put: can a range be named using a variable? e.g. Set Rng = "Range" & N Then Rng becomes Range1, Range2, etc in a loop. This works to name sheets as variables ( sh = "Sheet" & M). Doesn't seem to work with a range name. Get "type...

Hi I have a sheet which has different control buttons (developer-->insert) and different macros are assigned to these buttons. I created a macro to move the sheets around. How can keep this sheet active even after moving it do different location (order, for example after sheet2 or 3 or 4 etc). I...

Hello! I wrote this function but it does not work: =IF($I$28<=D17<($I$28+7),G28,C18-$C$28*0.2) I want the IF function to check the date at D17 to be between the date $I$28 and $I$28 + 1 week. How do I do that? Secondly, I want to calculate the mathematical function C18-$C$28*0.2 but I want...

Hi I wrote the code below but did nothing. What this code supposed to do? Thank you so much. ActiveWorkbook.Colors(5) = RGB(255, 0, 0) https://docs.microsoft.com/en-us/office/vba/api/Excel.Workbook.Colors

Hi I created simple form (2 text boxes+ 3 cmd buttons). I wrote a code to show the form (no problem) an wrote another sub to initialized the form (not sure how important is that but I read somewhere that I need to do that). I put both sub in the same Module. I read that the UserForm_Intialize()...

Hello, I have a sheet with over 50K companies, now here is the thing, some companies repeats themselves in the sheet because the have multiple licenses. What I would like to know is how can I know the total of companies "by name" even tho they have multiples licenses. Hopefully I wrote the...

Hello! I have monthly financial data with the months across the row and the financial metrics down the column. I need to aggregate these months into quarterly, annual, or quarterly/annual displays for the user. I wrote formulas to generate the correct headings based on the user selection...

I created a user form and changed the name of it to SearchForm. When I wrote a sub to call on the form, I keep getting a runtime error 424 saying that there is an object required. Not sure why it isn't working now when it was working earlier. Any help would be much appreciated. Heres what I...

Hi good people!, my friend's pc just suddenly gave a problem. He was opening files and everything worked, until he opened another. Cut, Copy, Paste, Delete, "drag and drop", everything is greyed out. I wrote the "application cutcopymode=true" in the workbook beforeclose event, but even with...

Hi, I have two columns in a spreadsheet - one is a year and the other a data validation field yes/no. I want to count the number of instances of yes/no by year so wrote the following formula =COUNTIFS(QNSAPList!$W:$W,"2011",$X:$X,"Open"). However, it's returning zero. Can anyone tell me what...

Hello there, I require in Column R & S only in “DataInput” sheet, when I wrote in cell. w then automatic comes Winner & l for Looser. Require VBA coding. Regards, Rahul

Hi there, In column A, I have IDs which are not unique, B date, C description, and D amount. In cell E1 I wrote 250000 which far above the maximum amount in column D, in E2 I wrote E1+ 1 and extended the formula to the non blank last cell. I am trying to get a list of duplicate items. I wrote...