vba

  1. V

    Copy Range from Multiple Sheets and Paste Link into a Single Sheet

    Hello, I am new to VBA. I have the following code that works great except that I need it to paste the range as a link to the original range. Help!!! Sub CopyColumns() Dim Source As Worksheet Dim Destination As Worksheet Dim Last As Long Application.ScreenUpdating = False 'Checking whether...
  2. M

    VBA Chart Series title with multiple cells

    Hello All, I am trying to make a more generic way to create a XY scatter chart and add data to the chart. Here is some test code. Sub Test_Add_Series() Dim DataTab As String Dim PLTab As String Dim Xrange As Range Dim Yrange As Range Dim Trange As Range Dim Snu As Long DataTab =...
  3. Praedico

    Access/VBA doesn't understand ComPort data after upgrade to Win11.

    I have an Access DB that can (in Windows10) get data from a GPS receiver assigned to a com port. The organization has decided to upgrade our computers to Windows 11, now Access/VBA no longer understands the data coming from the GPS receiver. I am adding an image showing the "data" Access sees...
  4. M

    Excel Table - How to Append to Access Database Using VBA

    I have an Excel Sheet that holds a Table (Table named "PST_2" ) that I need to append to an Access Database (DB named "STATS.accdb"). I need to do this while the user has Excel open, and without opening the Access application, as some users may not have it. I know how to initiate appending...
  5. R

    How to fix vba delay in runing the date rule

    I have a worksheet with a long Vba code to run many rules in the sheet - One of these rules is to insert today() date in cell "D11" when any edit happen in cells ("E5 or G5")- the problem is that I face a lot of delay in this rule to apply after many times try and sometimes it run after...
  6. S

    VBA Script to merge cells based on cell value

    I'm having difficulty finding a way to merge cells based on their values. Here’s what I need: I have two dependent dropdown menus in columns D and E. When the value "DD9900" is selected in cell E12, I would like a script that merges E12 with E13 and also merges D12 with D13. To clarify, when...
  7. D

    Hide Rows Based on Another Sheets Values

    Hi, I'm trying to hide rows on an excel worksheet ("SOW & RHS") based on whether or not a specific cell of another worksheet ("Labor & Material") is empty. i.e.: If cell C5 of worksheet ("Labor & Material") has any value (if it is not empty) , row 24 on worksheet ("SOW & RHS") should be visible...
  8. F

    VBA, Selection with xlToRight but want to end at column JK

    Hi all, Hopefully an easy question for you :). I am very new to VBA and I am currently fiddling in an already made document to try and understand what is happening. It is an Excel sheet where we want to copy data from various sheets into a single sheet. It starts with searching the input...
  9. M

    Highlight a row in excel

    Hi - I have an excel sheet which has numerical data in columns J through AV. I would like to highlight rows where all columns have data as either 0 or blank. How do I achieve it through either conditional formatting or formula? Example below - (In this, I would like to highlight row 2). Thanks...
  10. A

    How can I create a button to insert a new row and update related formulas?

    So I have a budget spreadsheet that is a list of values in different sections, a total at the bottom that sums each value in the section, and a overall total that sums all the section totals. If possible I want to create a macro that allows me to press a button and insert a new row into a...
  11. H

    Using XLOOKUP in VBA to lookup value underneath specific header name (columns can change depending on worksheet)

    Hello, I am trying to build an XLOOKUP into my code that will lookup the first value underneath the header "STATE CD 1", as my columns can vary depending on the workbook. I am not sure if I should use the lookup in this code, or if I should make it separately so I am open to feedback on this...
  12. E

    I have 1 UserForm and want to save to different sheets in the same workbook

    Hello all, I think this topic has been discussed in many posts here and other forums. I'm sorry for the Clickbait (for some), however, I was unable to solve my problem.... I have a workbook to register my expenses, so I have a Sheet for every month of the year: so, first sheet is for January...
  13. M

    Sum the values between two specified column headings - number of columns between will change

    Good morning all, My column headings are in row 7. The below code works fine. However, the ActiveCell.Formula = "=G8" needs changing (the active cell is the Subtotal column). I need it to sum the values between two columns called "Calculated payment based on time and costs" and "Subtotal"...
  14. S

    Return error if "Filter" doesn't return the required entry

    I currently have the sub-Macro below which filters for Columns A and B (for Strings Asset and SN), and then copies the value. What I'm trying to figure out is how do I set it so that if no results are found for either, the macro would generate an error instead of crashing/copying just the title...
  15. S

    Macro crashes since update of excel to v.2408.

    Hi all, I seek your help again. I have this VBA: Sheets("Data_analysis").Select Set pvFld = ActiveSheet.PivotTables("Data_analysis").PivotFields("Entered on") strFilter = ActiveWorkbook.Sheets("MAIN").Range("C3").Value pvFld.PivotFilters.Add2 xlCaptionEquals, , strFilter It worked...
  16. R

    TextToColumns, VBA to uncheck "Treat consecutive delimiters as one"

    The below code parses a single column address to dedicated columns for Address1, Address2, City, State, Zip. The code first tests the original column and places commas so that TextToColumns can do its work with commas as the delimeter. My problem is, Excel keeps returning the TextToColumns...
  17. R

    Export excel file as PDF into a targeted pc folder based on cell value

    I have a code in excel sheet to save the currant page as pdf into pc folder based on cell value + current month text and it's working perfectly with just one problem - when I have an old file already saved in the folder and I need to save a new one with the same month name, the new file...
  18. R

    VBA Queries refresh and Save data as TXT

    I wrote this code to refresh all my queries first and save the "Schedule" table as a .txt file. (Table: "Schedule" is coming from query) However, the problem with the code is that it does not refresh the queries; it just saves the table's existing/outdated data, which is not required. I want to...
  19. R

    Msbox VBA code when cell value is changed

    I'm stuck with a part of long VBA code in my worksheet to pop up Msgbox in case if cell vlaue was edited - here is the probelm I have a worksheet that collect data from other sheet with formulas to show me the employee records and ID image when I only insert the employee ID number in Cell "E5...
  20. S

    VBA - Overpass default Scripting.Dictionary Keys comparison

    Hello, I am currently working on a set of two classes: one being a custom object model, and the latter a custom Dictionary class, with my 1st class as key, and the items being arraylists. I am facing a problem for which i am completely aware and kinda anticipated. It is explained here in...

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
Back
Top