error

Hey everyone! I need some help tweaking my formula to get rid of the #VALUE error it's generating. Formula Goal: if range 1 (date format) is a Saturday, then sum the relevant cell in range 2 (number format) >> count how many of something is being done on Saturdays specifically out of all the...

Hi since i updated my code the error 70 "Permission Denied" keeps me from activating my search form. Const SEARCH_BLANK As String = "[BLANK]" Sub FilterData() Dim ws As Worksheet Dim i As Long Dim lastRow As Long Dim matchCriteria As Boolean ' Change "Sheet1" to the...

Hi to all, Here I am again to bring my problems with vba. I have a workbook where I have a few sheets, that all have one table and one pivot table. To update the data on the pivot table, I have this code, that runs when I change the column "Valor s/ Iva" on the table: Private Sub...

Just curious if anyone has ran into this issue before. My work computer does not allow me to open my macro enabled workbook. My IT department is not sure why. However I am able to open it on my personal compute. Does anyone have any idea: Is there something wrong with excel on my computer? Is...

Hi, I have a large Excel with a lot of data that requires a lot of calculation. The issue is that I can't even open it without freezing and have an message Excel not responding. Is there a way for me to open Excel without really open it to switch from auto calculation to manual calculation ?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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