vba help

  1. 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"...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. H


    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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. B

    VBA add cell value if worksheet is included in workbook

    Hello. I have a system that generates reports and names the worksheets based on a numerical sequence xx-xxx (department number). I would like to add a report title in cell A3 with the department's name based on the worksheet name (department number). The code below works as long as all of the...
  17. B

    Is there a better way to apply conditional formats with vba?

    Hello everyone. I have a large macro that has evolved over time and has become quite slow. I'm making an effort to go through the code to clean it up. There are two conditional formats in the macro that apply different conditions to the range A8:I500 based on the left values in column A. I'm...
  18. Johnny Thunder

    VBA Help - Multiple If/ElseIf Statements

    Hi guys, I am working on a project and found myself spinning in circles with this code. Hope someone can steer me in the right direction. Background:I have a menu grid with the name of 4 sheets that a user can have added to a workbook based on "True" or "False" from a drop down next to the...
  19. D

    VBA to copy values in column and Paste only values on separate sheet in workbook

    I am in need of a Macro that allows me to copy a column of 150 lines and paste only it's values in a separate worksheet in the same Workbook. Currently I have: Sub GroceryDispatchColumnCopy() Sheets("Grocery Dispatch").Select Range("E3:E150").Copy Sheets("Sheet1").Select...
  20. D

    VBA Button to clear column of text and leave just numbers

    I am pasting into column A row 1 and need a macro I can apply to a button that takes out all text from what has been pasted and leaves every row with the same digits just without text. Often times there will be up to 75 rows pasted in column A. I need a macro that I can apply to a button to...

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