excel & vba

  1. M

    Formula processing is Extremly Slow

    I have been using this formula which macthes the List of Cells to Raw String and if match found then write same value. This function is working fine but it stucks and sheet gets stop due to the large set of data. I would appreciate your help if someone can share a fastest way. Sheet is stuck...
  2. P

    Automatically Adding to a list when a folder is created?

    Good Morning, What I am looking to do might not even be possible, but I am hoping that it is, even if I have to try and figure out Access to make it work. I work for a construction company, and the way we add jobs to our server is: Job number - Job address - Job name example 1500 - 123...
  3. C

    VBA Extract specific data from txt file

    Have a .txt file that contains specific data that needs to be extracted and placed into corresponding columns in Excel. My log file has the following structure: . . . === NAME: xyz123 === d1: ABCD, d2: EFGH e1: TRUE (12345) . . . . == Specific text == Not every log part ends with the ==...
  4. A

    VBA Codes clashing with one another

    Hi, Here is my sample file. Can you please advise how I can fix the following codes so that they do not class with each anymore? A snapshot on what the code should have done (but it couldn't): 1) If "Shipped" in column AU and no "x" in column AX, then return "Rollup" for all empty Sales and...
  5. H

    VBA code using SumIf/Index/Match (Error Codes)

    Hello. I am a bit new at using VBA for complex and detailed codes and I have really only used it for simple basic needs. I would say I have an average to above average understanding of it though. I am working on project in Excel where a User Form will open and display a Total Forecast Amount...
  6. P

    Multiplying Textbox Value

    I have the below code that works: Private Sub CommandButton1_Click() Dim cell As Range For Each cell In Range("I2:I2") cell.Formula = Replace(cell.Formula, "100,", TextBox1.Value + ",") cell.Formula = Replace(cell.Formula, "260000000000,", TextBox2.Value + ",") Next cell End Sub But, I would...
  7. J

    Having trouble copy pasting specific text into new column/row

    Hello, trying to automate a big spreadsheet with 1500+ rows and not having much luck when trying VBA myself. I have 3 columns. Column A which contain cells with "Sum of" followed by a locale code such as en_US, the locale code changes. Following each "Sum of" cell there is a number of...
  8. U

    “Dates” set as General, should be set to DATES

    I have my VBA script working correctly, however, I do not understand why the dates on column "C" are set and changed to "General" when they should remain as Dates. If my dates do not land on Sheet 2 as Dates then formula on column "E" will not display Days Outstanding as sheet should display...
  9. S

    Excel VBA Auto_Open() detect what workbook you are opening

    EXAMPLE CODE NOT REAL: Private Sub Auto_Open() If ( Activeworkbook.isNewDocuement() == false ) then Goto :EOF End If ' [code example] ' [code example] ' [code example] :EOF End Sub I have a macro that runs each time excel open which works great but now I want it...
  10. S

    trying to run this code through customized ribbon and place it in module

    HI, I'm trying to run the following code from customized ribbon and wants to run this code for all sheets but when i do that it just skips the second case and exits the program. Can you please assist how can i make this to run in module for all sheets. I'm fairly new to VB and i really...
  11. K

    Saving an excel 5.1/95 editor customization file (from 97-2003) format to 2016 format .xlsm format

    I have upgraded to Excel 2016 from excel 97/2003. I have several workbooks with macros in the old format. When I attempt to save them to the .xlsm file format, I receive a message stating that: "This workbook contains one or more of the following features that are not supported by the...
  12. M

    dynamic chart using data in rows seperately

    I have a list created by reading data every 5 seconds (6 inputs at a time). I want these rows of data put on a chart one by one. I've done this for a short list using the record mode as I don't know a thing about VBA. however, the list contains over 500 rows of data. so loop would be solution...
  13. F

    Outlook calendar export VBA with range period

    Hello guys, I am trying to modify a code that I found in order to export my calendar appointments in Excel. I need to export "Subject", "StartDate", "EndDate" and "Category". The main issue is that I want on a specific period of time by an Input Box, first to enter the start date and then the...
  14. G

    Structured vs Explicit cell reference using index match issue

    I'm using Index-Match to match Full Names with head count in that party. I have it working but it uses both the structured and explicit cell reference. I can't figure out why when I add a new row in my table, the column with the index-match formula wont populate the last row. This is the formula...
  15. S

    Trying to get all sheet names in excel workbook and then give those names to new excel sheet and save it as csv

    Hi, I'm trying to copy column one of each sheet and save it to new sheet which will then be saved as csv file and name of new sheet should be pulled from old workbook. if sheet names are If ShtNames(i) = "Sheet1" Or "Error log" Or "JUMPER REPORT" Or "WIRE LABELS" Or "TERMINATION COUNT" Then...
  16. I


    Hello, I hope my request is possible. I need to create a code to go through the data on a spreadsheet and create chart for each product block. There are might be multiple product blocks. I got code to create the first one, but I am pretty bad with loops and have no idea how to make it go...
  17. M

    VBA email from outlook - Excel pivot

    Hi, I went through http://www.rondebruin.nl/sendmail.htm however it did not help since I am not much familiar with writing VBA code. Can anyone help me with VBA to send email based on values in Excel pivot? I have embedded a sample excel file below:- I need separate email where column A...
  18. W

    Generate and attach pdf to email without dialogue box

    This is going to be a long one. I apologize. I found some VBA script online (this is not something I wrote and can't take credit for any of it) that allows me to export and save the active range as a pdf and it automatically attaches it to an email with some predetermined verbiage. I have...
  19. O

    Why does my Status Bar stop updating.

    I'm running a simulation with over 500,000 iterations. I've got screenupdating turned on on, statusBar display is on, and I've activated the status bar to print on the iteration number, but it prints out 6000+ and then stops. Could it be that the software is running faster than the screen can...
  20. S

    Excel VBA to unhide specific rows across multiple sheets

    I am looking to construct a VBA that unhides specific rows across different sheets in a workbook. I can write separate VBA for each sheet/row combination, but was wondering if I can put them all together instead? 3 sheets need the same rows unhidden that I already have code for: Sub Test()...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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