1. J

    VBA cant paste into destination file without hitting enter

    Hi All, Im having an issue with a simple cut and paste vba code which I have used previously. Im trying to copy from a range in one work book and paste values only into another. The problem Im having is, even after defining the workbook, sheet and cell location, Excel still asks me to hit...
  2. A

    Countif in power query

    Hello How do I execute the following code in Power Query? =IF(COUNTIF($B$2:B2,B2)=1,1,0)
  3. T

    "Can't execute code in break mode" when copying worksheet array to a new file

    I am trying to execute the code below to create a set of workbooks to send out various people in my organization. It copies a series of worksheets to a new file, breaks the links, and saves with their name and position number. When I step through this code manually, it works as intended...
  4. A

    Combo box Change Event twice

    When I make a selection using the drop down arrow, the change event executes once. However, if I type 1 character, the change event execute twice. I step through the procedure and I can see the code only execute once until to the end of the procedure and then my cursor changes to a wait circle...
  5. T

    Evaluate formula

    Assume I have this data on my worksheet from cell A1 through to B6: <colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody> 1 a 2 b 3 c </tbody> If In cell D1 I type: =MATCH(1,(A1=A1:A3)*(B1=B1:B3),0) and enter it "normally", I...
  6. A

    Convert macro

    This was recorded Sheets("Sheet1").Select Cells.Select Selection.Clear Range("A1").Select With ActiveWindow .SplitColumn = 0 .SplitRow = 1 End With ActiveWindow.FreezePanes = True Columns("A:A").ColumnWidth = 36 Columns("B:B").ColumnWidth = 36 Is...
  7. T

    Running an update query via VBA, execute command can't find the update query

    Good Afternoon! I have a series of updates to run on a table and I was hoping to automate them with one click. I tried using the execute method as described here: https://www.fmsinc.com/MicrosoftAccess/query/action-queries/SuppressWarningMessages.htm The problem is, when I put my query name...
  8. N

    Executing Macro by clicking Cell Contain.

    Dear Sir, I Want to execute Micro by clicking Cell "A3" Containt. Can It Possibel.
  9. M

    no value given for one or more required parameters on execute statement in vba

    Hi, i have "Run time error no value given for one or more required parameters" on execute statement in vba I am trying to connect Excel as database. i am going to execute update query from one excel workbook. Public con_daily As Connection Public con_ele As Connection Public com_daily As...
  10. Y

    Way to execute vba code out of a cell w a double.click

    In Access & VB a field has the functions/methods where you can execute code subroutine on double.click. I see how to call a subroutine from a button... It seems there should be a call like Range.ondblclick
  11. C

    Cycle multiple Excel functions in single macro

    I am trying to create two macros and would really appreciate some help on this, as not sure where to begin. 1. AutoSum Min on first execute then AutoSum Max on second execute (if the macro is executed in the same cell). Then beyond the second execute, the macro should cycle through these two...
  12. K

    Execute a .exe file from a VBA

    I have about 100 programs that I am testing. I have aspread sheet to track the results. I am trying to execute the programs fromExcel using hyperlinks but that has problems. Would it be possible to do thiswith a VBA? Maybe use a case switch for the programs?.
  13. O

    How do I find a value in a row of formulae

    I have a row that contains 5000 values based on formula that I see when I highlight the cell. I can find the max and min values, but I don't know where they are in the row. When I execute a Find, it tells me it can't find the data. Is there a simple way to go about this?
  14. S

    Convoluted If/Vlookup formula? Not sure how to code this one.

    <tbody> Schedule Schedule Name %1 %2 %3 %4 %5 %6 %7 1 bla1 2 0 40 6 0 8 0 100 100 2 bla2 100 100 100 100 10 3 immediate 100 100 100 100 100 100 100 </tbody> Ok.. so this is a little complicated. I currently have an If statement written that says...
  15. V

    Execute a macro based a text in a column which is constantly changing by formulae

    hi people, Thanks in advance, and excuse me for my average English. I am very new to VBA. I have a excel sheet, where cells in column B will change on predefined time frame, ex.5 minutes. I want to execute a macro when any cell in that column comes to have specific text, say YES. Please help...
  16. F

    Actions of Macro depend on the value of a cell

    I am working with the following macros. I want to change the action of the macro depending on the value of a cell. If the cell = 1 then it should execute the second macro. If the cell = 2 then the macro should execute the first macro. Can anyone help. Thanks in advance Sub Callapes() ' '...
  17. R

    Loading CSV in to ram from network location is taking too long.

    Hello, I have had a worksheet working fine for 9 months. It normally takes 2 minutes to execute the macro in this worksheet, but for some reason in the last two months it started taking 6-8 minutes to execute. I was able to isolate the code that was taking so long. Open kmfile For Input...
  18. M

    Execute Macro Based on Cell Change -> without using Enter key

    The below macro creates a filter based on the value in A2. I want it to execute every time A2 changes. A2 is a cell reference to another sheet (pivot table). The only way the filter currently updates is if I press Enter in A2. I have tried writing this several different ways but they all require...
  19. I

    Macro to Auto-Scroll

    Hi, my problem is that i'm using an aplication to read the data in the TCP/IP port and send it to excel using DDE(Dynamic Data Exchange) . The aplication is "TWedge", So what i need is a macro to keep seeing the data on the screen when new data is placed in a row because the program does not...
  20. J

    how to add a button to my Excel permanently

    hi all i created a button, created with Custom UI Editor. but heere create the button for the Actual Book. i want so so do this: 1) click on button, open a File and execute myMacro. how to do this? thanks..

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