excel marco

  1. E

    VBA Auto Filter and Copy Paste to a New tab then rename the tab

    Hi to all, I am a newbie and is learning a lot from this site. I am also hoping that someone can help me with my problem with the VBA code I created via recording a macro. I have a 9 column master data that I need to filter based on column C "Department" there are times that two departments...
  2. N

    Open Other File and Run Marco with (Application.Run )

    i need to open FILE B and run macro in FILE B My Code Sub Marcodd() Application.Run "C:\Users\THJunsomPa\Desktop\3.Master ok Sell-out Promotion_Mar'16.xlsm!B_Clear" End Sub This Code is open File but cannot run macro[B_Clear] in file This Error
  3. E

    simple macro to execute every 15 seconds

    I need a simple macro to execute every 15 seconds. The macro is to call two other macros every 15 seconds .Here is my code: Sub ibstartstop() ' ' ibstartstop Macro ' Start stop running IB10 sec macro every 15 sec ' ' Keyboard Shortcut: Ctrl+x ' Application.OnTime Now, "ib15sec" dTime = Now +...
  4. J

    Moving text to another cell dynamically with macro

    Hi everyone! I´m new to the forum and VBA/macro-programming aswell. I need help solving a quite easy(I think) problem. The background I've an excel with a couple of thousand information that should be on the following form Account# data1 data2 data3 Right now, the excel looks like this: Column A...
  5. F

    merge two marco's into one. Please help.

    I have a timer macro, I need to add my protect workbook macro but can not get it to work. here is both of the codes. Sub Protect() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Protect Password:="456" Next ws ActiveWorkbook.Save Windows.Application.Quit 'closes wkbk & excel...
  6. F

    Macro to delete workbook.

    I have spent HOURS putting together a workbook for my job. I have found out that my direct supervisor has been stealing MY work from my workbook and is taking credit for all the work done so far. I even found a macro in my workbook that auto updates to his excel. I want to add a hidden button in...

This Week's Hot Topics

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
Top