vba help

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

Hi Guys, First time on the site. We found the following code online: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub Application.ScreenUpdating = False ' Clear the color of all the cells Cells.Font.ColorIndex = 0 With Target ' Highlight...

I a very green to VBA (self taught in the last 3 weeks)... I created the below code, which works but is VERY slow. I am hoping someone can help as I still need to protect/unprotect the worksheets which is only going to further impact performance. The code has 3 intended results:1) Reading a...

Hello everyone. I'm trying to create a macro that will insert a new tab called "SheetList" at the beginning of my workbook. This tab has "Table of Contents" in cell A4. I would like for the sheet names to be listed starting in cell B5 and continuing down until all sheets are listed. Beside the...

I have some VBA that has worked in the past without a problem but will not run anymore. The VBA deletes all the sheets in a workbook that are not listed. If searched the forums and there are several posts that suggest replacing "Sheets" with "Worksheets", but this did not work for me. The error...

Hello everyone. I'm trying to delete sheets that are not included in a list. I've found some posts that explain how to delete sheets if they are not included in a list, ie an actual range cells A1:A10. However, I would like to delete the sheets listed within the VBA code not a listed range...

Hi Guys, I am using the below code to do checks for a automated holiday spreadsheet. if first checks to see if the user has enough holiday "<26" and then checks to see if they are not trying to request more that 10 days " < 10 ". the dates are declared in two cells From " B21" To "C21" what...

Hello. I'm hoping you all can help me create a macro that will loop through multiple sheets to identify errors and log those on an ErrorLog worksheet. The excel file is a system generated report with 115 tabs. Column A = Descriptions and Column B = Values. If Column A is blank " " (there...

Hi Guys, I was wondering if anyone knows how to use Ron De Bruin Mail_Range macro to email a pivotal table. I have been using the below but have had to keep manually changing the Source Range. I was wondering if anyone knows how I can amend the Source to just refer to the active pivotal...

Hi Guys, I am trying to automate the emailing of a Range using the below, but I am getting a Run Time Error 438. can anyone help. Sub EMAIL_Mail_Test() With Sheets("Sheet1") .Range("E2").CopySheets("Sheet2").Range ("B7") Mail_Range.Mail_Range .Range("E4").CopySheets("Sheet2").Range...