vba help

  1. M

    VBA - Deleting all rows in data for all past dates

    Hi all, Need help with a macro Essentially we have a sheet of data, changes every day. Many columns but Column C contains the column of end dates. I want to filter the data, and then delete every row in the data where column c contains dates before today (the day we run the macro, so changing...
  2. A

    Add Row Above Date

    I am working on schedules and want to add blank rows to each schedule for any changes that need to be annotated. So I want to add 2 blank rows above any date that I find (except the first date because we're not scheduling for the past)). I have typed and retyped 5 or 6 different ways and I am...
  3. B

    Excel crashes when running this VBA

    I'm using Microsoft 365 for Business - Excel version 2107 I have a workbook with multiple tabs and have the code below that deletes worksheets that are not listed in the array. I run this code on a monthly basis to generate reports, and the code has worked without any problems in the past...
  4. Johnny Thunder

    VBA Help - Create Conditional Formatting to Sheet

    Hello Everyone, I am stuck on a project that requires a sheet to get a refresh to the conditional formatting to a sheet. Whenever a user Adds Rows to a sheet or duplicates the sheet the conditional formatting seems to get messed up by duplicating rules and changing my ranges from being entire...
  5. X

    Macro runs in debug mode perfectly fine, but when i try to run it normally it errors out

    Hello all. The title basicly says it all. I have a macro which just adds sheets with a desired name. When i wrote the code i looked if it works as intended in debug mode. But as soon as i wanted to run the macro normally it errors out. the code that i run is as follows: Sub killast() With...
  6. X

    Vba to save as with path and file name

    What i ultimatly want to achive is that i save the active workbook under the name of the date today in the path i choose. I wrote a little code for that, that partly helped me. the code is as follows: Sub save() Dim location As String location = ThisWorkbook.Path ChDir location & "\History"...
  7. X

    Several VBA Userforms Questions including formulas in the Userform and uneditable textboxes.

    Ok. I am fairly new to the whole userform thing, but i find it really useful for what i want to do with it. But i still got several questions about it. 1. I have managed toget a fairly big userform to work and enter all those values in a table. But i figured out that when i use the userform to...
  8. X

    Vbe to search for selected cell value in another table

    The situation is as follows: I have a "main table" which is *full* of data. Im talkin abut 1500 entries. Then i have another table, which is for filtering. I have already figured out how to filter the table for what im looking at. But what i now need is a way to search for a selected value...
  9. N

    Dynamic range without 0 in VBA

    Hi everyone I need help with VBA. Thanks for your help in advance. I have summarized the topic below. I have a data of 37 lines. I want to take this data into a table on another page, but I want the value 0 not to appear in the table when retrieving the data. The values in the data are...
  10. B

    Copy Data to Running List on Another Worksheet - Need to add sheet name from selected Range

    Hello everyone, I have some vba I use on a workbook with multiple tabs. The code copies a selected range from a tab (the range will be a single row - columns A - H) each time it's selected and pastes the selected range to the next available row on the sheet named "List". 2 Questions: 1) I...
  11. H

    HELP!

    I have a sheet (sheet 1) that I will be putting a 3 digit number in one tab that will calculate in 2 other cells I want to run a macro that will read the row number and read the cell A, C, E and then go into the other sheet (sheet 2) and find those numbers that are in cell a and insert the...
  12. V

    VBA code to add blank row when change in data occurs in specific columns

    Hello, Sorry if this post has already been written before but I am very new to Macros and am having trouble finding a code that works the way I would like it. So I have a payroll report that I run all the time and I ran a simple macro to get the formatting down to which columns I need but I am...
  13. B

    Excel crashing when running .Delete

    I'm on Microsoft 365 for business with Excel version 2006 (Build 13001.20266) Excel is crashing when I run code with .Delete. Any idea how to get around this? I have some code that deletes sheets not listed in an array. This Example 1 code has worked fine in the past but started crashing excel...
  14. T

    VBA code to loop and extract data

    I have another sheet were a user selects a name. Is it possible to have a macro loop through the data and return the event type listed below the employee along with the date. This is just a snippet of the data. An employee will have multiple event types. I'm not sure if this is even possible...
  15. S

    Returning common substrings

    Hi everyone, First off, LOVE this forum. Has helped me a lot before. I am however feeling stuck this time around and haven't really found a good solution. I have a lot of rows with various product names, what I want to do is to go through the names and return some of the substrings in order to...
  16. B

    VBA - Find and Replace - is there a better way to do this?

    I have pieced together different bits of code over the past few years to format a P&L report being generated from an accounting system. The vba is starting to run slowly and I'm trying to clean it up to make it run a faster. The report being formatted has 100 tabs and the code formats each tab...
  17. Johnny Thunder

    VBA Help - Cell1 = Cell2 But if Cell 1 is blank return blank - Excel 2016

    Hello! I am kinda stuck on something so I will explain what I am doing. I have a Form that looks kinda like a Web portal with 18 fields/dropdowns that a user can populate. This tool also has the ability to recall these fields if the user knows the tracking number, then all the fillable...
  18. E

    VBA - insert new row Y, copy row X and paste format and formulas in row Y

    Hello Sorry this could be really simple but I've spent hours and feel like I'm going round in circles! Any help would be really appreciated. I want a macro to insert a new row below the current active cell, then copy and paste format and formula from row 8 into that new row. I have been...
  19. D

    Need Help with creating a pop up window for an inventory system- VBA

    I am trying to create an inventory based database for our online orders. There are 10 different bundles that consist of multiple products that can also be shipped individually if not apart of a bundle. What I want to be able to do is create a day by day process where a window pops up asking what...
  20. B

    VBA to Delete Rows if Cell Length in Column A = 14

    Hi everyone, I'm trying to modify the VBA found: https://www.rondebruin.nl/win/s4/win001.htm to delete rows based on the cells length instead of the cells content. The website's example deletes rows that contain "ron" and the VBA works as expected. I would to like to modify so that it deletes...
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
Top