macro code

  1. M

    macro code to remove an element form an array and accept an element from an array

    hi i have made a macro code to accept an array from an excel cell. but right now i am not able to accept a value. for ex "Series 1, Episode 4 Including the 1980s story of a campaign for a hospice to be built in the Highlands." from the above example i need to accept series 1 in an array. and...
  2. V

    Excel Open workbook- crashing when trying to open

    Hello All, I have a code which is working fine for couple of files but crashing when trying to open a particular file. Workbooks.Open (UserFolder & Left(FileObj.Name, InStrRev(FileObj.Name, ".") - 1) & ".xlsm") Workbooks.Open (UserFolder & Left(FileObj.Name, InStrRev(FileObj.Name, ".") - 1) &...
  3. S

    Need VBA code to cap only select words

    Need VBA code to cap only select words that will be found throughout columns A-F and a list of the select words that the code would look for would be on a separate worksheet named “words2” in column A so that additional keywords could be added on an ongoing basis.
  4. S

    Need a macro code to Cap the first letter of words in entire columns

    I have been using a code that had been working fine but with the new data I'm using it has a flaw. Below is first the actual code I'm currently using followed by an explanation of the flaw I am now encountering. Sub ConvertSelectionUpper_V4() ' hiker95, 08/27/2014, ME800718 Dim c As Range...
  5. S

    I want to create a drilled down list of VPs for a set of managers matching with a provided list of VPs in excel.

    What i need to do is - 1. I have a base data sheet(Data) with user id(col D), Username(col F) and Reports to(col I) data of all employees. 2. i have a set of unique managers and their ids in a sheet X. 3. In sheet Y i have a list of selected managers and their ids which are not in sheet...
  6. C

    Using Command Buttons and UserForm Lists in Conjunction

    Hi all, I have a macro running in which I am using a UserForm with a dropdown list. The list has three options (pulled from sheet called "Daily"). The operator is required to select one from the list and then continue or cancel. The command button to continue is required to copy the option...
  7. D

    I Need Macro Code To Make A Button To Uncheck All Checked Boxes ... None Of The Checkboxes Are Named

    I Need Macro Code To Make A Button To Uncheck All Checked Boxes ... None Of The Checkboxes Are Named Please Help - Thanks :)
  8. E

    Button in sheet1 with macro, copied to sheet2 and sheet3, is not working

    Hello guys, I have this macro code in Sheet1 assigned to a button named Combination. I copied the whole sheet twice and moved to end. So they have the same data content and hopefully the macro in sheet1 will work as well in sheets2 and 3. But it's not. I just copied the code from VB codes Excel...
  9. O

    Hep With Macro Code for generating an email with specific data

    I am trying to get a macro code to have an email generate everyday on it's own, with data that changes every day. Basically this is for work, this tracks the dates of employee's corrective action and after 91 days, the corrective action "falls-off" and I need it to generate an email with the...
  10. F

    Need a Macro with Loop to Insert new Worksheet

    <TABLE class=tborder id=post2776275 cellSpacing=0 cellPadding=6 width="100%" align=center border=0><TBODY><TR vAlign=top><TD class=alt1 id=td_post_2776275 style="BORDER-RIGHT: #ffffff 1px solid">I need to insert 10 new sheets in a workbook, base on the value in Column B. I want to get it in a...
  11. D

    Previous Record and Next Record Macro Code Needed???

    I recently followed the following tutorial listed below to create a "userform": http://www.contextures.com/xluserform01.html I need a simple macro to add a "previous" and "next" button(s) in the userform that I have created. The data is currently input into the userform interface, and copied...
  12. M

    Extracting multiple cells from different workbooks to a master workbook

    hi there, I have read through several threads on the use of macro to assist in extracting data from different workbook to a master file. But I can't seem to find a solution that is able to assist me. I have a total of 100 files where I will like to extract selected cells from individual file...

Watch MrExcel Video

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