I'm trying to split up an Excel in several excels based on a list of values in another Excel.
Let's show an example:
You see that in the top left Excel there is a list of values. My script starts with the first value 'binnendeuren' and search that value in the first 3 columns of the...
So the function is working as how I intended, just that after it finishes saving as it keeps the last workbook opened and the last created worksheet still opened. how do I prevent the error from popping up?
Dim BranchField As Range
Dim BranchName As Range
Theres no merge cell in this sheet. That sheet is locked.
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A11") <> "" Then
Range("B1:L11").Locked = False
ElseIf Range("A11") = "" Then
Range("B11:L11").Locked = True...
I am trying to run a User Form I just created and keep getting stuck on this error in my Advanced Filter. I have confirmed the data and range information but can't get past this. The exact same code runs fine in a different user form. Any ideas for a newbie vba user?
I've been struggling with this for hours now.
I believe the solution is simple, but I can't figure it out.
The complete steps being taken are as follows...
Open external workbook
Manually select range (which varies often)
Press Ctrl+C or right click select Copy, to copy selected range...
Hello. I made a long macro for myself and coworkers that references one static workbook multiple times. However, I have to edit the coding behind it once in a while and resend it. When this happens they are told to delete the others and make sure the name is the same. However, some are not tech...
Done some searching and sheet is not protected as others have had the issue with - its just being created as a new workbook.
So this is part of a word macro I am updating that I wrote before, but inside the macro I call the Excel creation function. The goal is I want to create an excel...
I have a rather irritating problem that does not make sense to me and I am hoping that someone can help please. I have some code that:
Creates a list of files to be opened
Opens each file in the list and scrapes some specific data from each file opened if present
Thank you in advance for taking the time to read this. I've tried to search for the answer but to no avail so I'm hoping some very kind person will be able to help put me out of my misery.
I'm trying to search for a specific term within a column of a worksheet, if that is found...
Hello, I am in the process of transferring a lot of the sheet calculations and conditional formatting into vba for efficiency and in the process I am receiving an error that I cannot seem to figure out, "run-time error 1004; method range of object worksheet failed". I have attached all the...
Hi- My Company's software macro creates hidden names in our workbooks making them clunky and unnecessarily large, so I am trying to get a macro to first unhide all names in the name manger, then delete all, except the print range. Except I am gettin a 1004 name syntax error on the n.Delete...
Looking for a little VBA love. Current macro simply done by recording. So I couldn't screw up the language code.
I have 2 sheets: 1 for Brands and Brands Top Gain Loss. I would like to get rid of one sheet and allow a macro for Sort by "Dollar Sales" and "Dollar Sales Chg YA"...
I have a dynamic equation that is filling across multiple cells, so until the equation is completely generate, I have not included the "=" sign at the beginning. I thought adding it would be as simple as Cells(i,j).Value = "=" & Cells.Value, but this does not work. I have tried the same thing...
My objective is to use the Worksheet_Change event to test if any cells requiring a value have been cleared, and then to retrieve the default values and put them in the cell. All the cells requiring a value have a named range, and all the default named ranges are the same, except with the...
Leveraging some posts online, I have created a macro that should allow the user to make filter selections on one sheet while having the actual pivot table on another sheet.
Dim ws As Worksheet
Set ws = ActiveWorkbook.ActiveSheet
Run time error 1004 when using sheet with more than 65000 lines .xlsx ). Even if they are not used.
I fear it has to do with the way I search the last used row.
Endrowhelp = Firstref.Column
First time poster to the board and fairly new to VBA macrosfor excel. Please bare with me on this post if it is confusing.
I have managed to Frankenstein together code that allows fora worksheet to be created based off of a template sheet, followed by adding anadditional...
Code for work, so posting just some of it..
Code that matter for function:
public function compare(...,table As Range)
dim i as integer
i = 1
table.Cells(i,1).value = "Test"
Throwing error "Run-time error '1004': Application-defined or object-defined error"
Any ideas on why this...
I keep getting a Runtime Error 1004 with a particular macro. The debug option always take me back to the "UsedRange" portion of:
If ws2.Range("A:A" & Rows.Count).End(xlUp).Row > 4 Then ws2.UsedRange.Offset(4).Clear
What's so frustrating is that if I copy and paste the contents to a brand new...
I am totally new to VBA, its my first code.
I wanted to create macro which could insert a row after finding different value.
I managed to write something like this.
Could you pleas check what is causing the error 1004 - Application defined or object-defined error?