1. L

    Excel Dependent Drop Down Error

    I am creating a dependent drop down where the drop down itself is located on the first tab of the sheet and the data that includes the dropdown options is on another tab. When the drop down and the data are on different tabs, I get the following error when entering the index match function into...
  2. A

    Subscript out of range vba error 9 excel, but it works on other laptops

    Hello Everyone, this is my first post in this community, I have this very weird problem regarding on the Macros files with excel, basically, there is a file using Macros working on my laptop, but I can't make it work on other laptops, those other laptops have the same office version, and even...
  3. D

    Carryover variable to called sub

    I am attempting to simplify some VBA code as it has gotten fairly long and is taking an extensive amount of time to run. I have multiple cubes that are updated weekly and I need to copy data from those cubes to a new sheet where I can manipulate and make edits. Rather than having three subs with...
  4. B

    Macro crashing and closing excel

    Hi guys, I need some help. I have a file with a few macros, and it was everything working as expected, but today my excel started crashing and closing when I run one of the macros. I was making changes to the file, and the macro was working, but sudently, It started closing excel. The code is...
  5. K

    "Problem Saving PowerPivot document"

    Anybody got any ideas how can I work out how to fix this problem? The error message below is popping up: ============================ Error Message: ============================ Value does not fall within the expected range. ---------------------------- Error occurred while setting the Sandbox...
  6. R

    SaveAs method not actually saving, wrong sheets being deleted (1004 Error)

    Option Explicit Dim wb As Workbook Dim ws As Worksheet Dim ws2 As Worksheet Dim rng As Range Dim r As Long Dim i As Long Dim er As Long Dim c As Range Dim sht As Object Dim wb2 As Workbook Dim fname As String Dim fpath As String Sub printshts() Set wb = ThisWorkbook Set ws =...
  7. M

    How to accept with code the next pop up "a program is trying to send an email message on your behalf"

    Hello mates, I have a question for my code, due to the next pop up appears when I tried to send an email, I saw in a thread in this blog with the same issue but, unfortunately in my company exist a lot of boundaries for Cibber security and I cant to press the send bottom in my macro without pop...
  8. K

    Can't figure out match function

    Hello, I'm having troubles searching through an array. I'm either getting a Mismatch or "unable to get the match property of..." error no matter what I try. I'm I deeply misunderstanding something? I'm trying to check if a value (string) appears further down the data-set, and if so print the...
  9. R

    Can you remove the green triangle using VBA?

    My code pastes a formula into a column of cells that also contains a data validation list. This formula returns information if it can find it. If it can't, then the user can select a value from the list in the cell. As a result, I get a green triangle telling me there is a data validation...
  10. B

    Code giving error when in module

    So, I'm having a problem with some code in VBA, I bet that it's an easy solution, but I'm a noob. I created a module, to check if it should call another module to sort my table. This code is throwing me an error "Object required" and it's pointing to the line "If Not Intersect(col, Target) Is...
  11. L

    VBA Code Fix - calculating a group of rows, excluding amount if column contains keywords

    Hello, I have the following code that is almost working, but I can't crack the last bit. I have a sheet where I have groups of rows (meaning a blank row in between each set) and in that blank row, I want to total the values of column N, but exclude the value from the total if column F contains...
  12. L

    VBA Code help - inserting columns in a specific order

    Hello! I have a code that is almost working, but I need some help getting the last bit. I am essentially trying to ensure that I have a consistent set of columns, in a specified order. Sometimes when we export a report from our financial tool, it doesn't give us all the columns we need, so this...
  13. S

    #Name? error when using user defined function

    Hello, I am creating a copy of an existing spreadsheet that has a bunch of macros and user defined functions. I am recreating the spreadsheet by starting a new workbook and copy and pasting the sheets into the new workbook and reorganizing the vba codes in the new workbook. As I am doing this...
  14. H

    Cell value as table array in VLOOKUP

    I have a cell suppose B1 = "APPL" I have a Table named "APPL_PRICE" which has Date column & Price Column. I want to VLOOKUP a specific Date( in A1) from the table using the reference of B1 Such as =VLOOKUP($A$1,APPL_PRICE[Date],2,FALSE) But instead i need to use reference of B1...
  15. Chris_010101

    Macro to clear filters

    Hello, Sub Reset_Filters() ' ' Reset_Filters Macro ' Resets all filters ' ' ActiveSheet.ShowAllData End Sub If there are no filters applied, I am getting the below error message when the macro is run (it's assigned to a button): And when I debug Kind Regards
  16. Chris_010101

    Excel VBA Help, Filters

    Hello, In column A, I have: =SORT(UNIQUE(FILTER('Headcount Report'!A3:A909, 'Headcount Report'!A3:A909<>""))) which pulls a list of unique values. In this list are locations by type, i.e St Albans - Yard, Colchester - Transport. The three types are "Office", "Yard" and "Transport" all appended...
  17. tazeo

    First Dax attempt, not working.

    I'm trying to create a visualisation that goes back 12 months from the selected date in a slicer. Using this video - I have this code: TRI P12M = VAR ReferenceDate = MAX ( 'Date'[Date] ) VAR PreviousDates = DATESINPERIOD ( 'Previous Date'[Date], ReferenceDate...
  18. B

    If and function with three conditions

    Hi Everyone, I'm trying to add an additional condition that doesn't seem to work and I can't figure out why. The new condition is looking at another column for the word "yes". My current formula is following: =IF(AND(COUNTIF(_AG22[Loan ID],[@[Loan ID]]),_AG22[Open...
  19. S

    Excel VBA: "Code execution has been interrupted" for Worksheet_Change(ByVal Target As Range)

    Hello, I wrote a vba code where if certain cells changes in value that excel will then run an existing macro. However, I keep getting an "Code execution has been interrupted" error almost 80% of the time that it runs. When I hit debug and press continue, everything works normally so I know...
  20. X

    Remove all rows where #NAME? is present

    How would I create a macro that removes all the rows where there is a #NAME? error in Column E?

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