wrote

  1. L

    Copy and Paste with VBA if a certain condition is met

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

    Count If Formula with a Defined Range

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

    I need help on vba

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

    Compile error wrong number of arguments or invald property assignment

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

    Range name as variable: possibe?

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

    keep one sheet activate - vba

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

    Can someone help me with these basic questions please?

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

    workbook.colors , what is used for?

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

    intializing a user form in vba

    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()...
  10. M

    Total of companies in sheet But having a problem

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

    Best Method to Aggregate Monthly Data

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

    Issue Showing a Form

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

    enable cutcopy

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

    CountIfs Function not working

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

    Cell Recognise Whole Word from its Initial

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

    Sumifs returning 0 for crieria existing

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

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