error #1004

  1. B

    Hidden Excel 4.0 macros can't be removed

    I use Excel 365 on Windows 10. I have a Membership database in an Excel workbook. Every so often, using a VBA macro, I copy a worksheet into a new book, remove all code from the copy and update various cell formats. I manually do some editing and remove some rows and columns and then run a...
  2. D

    Error in VBA script combining columns

    I have the following macro which does the following: Get the file names from a folder on Windows Combines the name with the folder name Hyperlinks the conjoined names How it looks in the table (the folder path is longer now and not sure if that is a problem in the script as to where the...
  3. I

    FormulaR1C1 + Error 1004

    Hi, I have written some code that looks for column headings to locate the columns of data required in my formula, thus returning a column number. So logically the best method of creating my formula in the cell is to use the FormulaR1C1 function in vba, however I have been unsuccessful in getting...
  4. A

    Delete Method of Range class Failed

    Hello, I am having an issue with the following code. As i am trying to copy filtered data from one page to another and then go back to the original data page and delete the transferred data. I keep getting hung on this line with the Error 1004 Delete Method of Range Class Failed...
  5. D

    Excel 2016 VBA Unprotect error for single user

    Good Evening, I’m wondering if someone could cast an eye over some VBA code I am using in a workbook. The workbook isn’t marked as shared and is protected, it is stored on a network drive so users can access it. Users all use the same version of Excel 2016 (RemoteApp hosted on a Remote...
  6. G

    VBA VLookUp to another workbook

    Hi! I have two spreadsheets (A and B) and I'd like VBA to do a VLOOKUP from A to B. Once the ranges are dynamic, I defined counters and they are working, I checked that. So there's the loop, contador stands for the counter in spreadsheet A. It should look for the content of cell Y&counter in...
  7. D

    Error '1004' Sort method of range class failed

    Can anyone figure out why this fails? I have done everything i can think of to make sure there is nothing to bother it. I have run it with the header cleared, I have deleted all rows with any illegal characters. Ii have added a little sub to do this too. I am using a script i that creates...
  8. T

    Worksheetfunction.Match Error 1004 on one code, but not the other nearly identical one

    I have 2 VBA codes that are almost identical to each other, the only difference is that one of them has a prompt for message box with input to fill in column B. Basically code 2 is identical to code 1, but with all the columns shifted one down (B-C, C-D, etc). Below is code 1 Private Sub...
  9. B

    Error AutoFilter Method of Range Class Failed

    Hello! I am relatively new to Macros so bare with me. Here is the code that I am working with: Sub Step4() ' ' Step4 Macro ' ' Keyboard Shortcut: Ctrl+Shift+N ' ActiveSheet.AutoFilterMode = False Range("K1").AutoFilter Field:=11, Criteria1:=Array( _ "#N/A")...
  10. M

    Run time error 1004 with vba ticklabels.offset

    Hello, I'm trying to use VBA to alter the parameters of my chart. But specifically with the Ticklabels.Offset - I get "Run time error 1004 - Parameter not valid", and I can't work out why. The code below works for the maximum scale and minimum scale, then gets an error where labelled...
  11. A

    Run-time ERROR 1004

    Hi All Good day for you........ I Run below code i get run-time error. Please need you help Sub GetFileCopyData() Dim Fname As String Dim SrcWbk As Workbook Dim DestWbk As Workbook Set DestWbk = ThisWorkbook Fname = Application.GetOpenFilename(FileFilter:="Excel Files...
  12. tlc53

    VBA Code Hide/Unhide Rows

    Hi, The sheet I am currently working on has numerous hide/unhide functions built into it. I am currently trying to to hide/unhide rows depending on the number of bank accounts selected. However, I haven't been able to get it to work at all! Can anyone see where I am going wrong? Private Sub...
  13. M

    Run-time error '1004' Method 'SaveAs' of object '_Workbook' failed

    Within an excel workbook I have created a routine that automatically logs the user and date when the workbook is initially opened. The Sub Workbook_Open() calls the routine. For most users it has worked effectively for sometime. However, myself and a few users are now getting the Run-time error...
  14. C

    Unable to get the FindNext property

    Hi All! I am in dire need of all your expert advise. I have already searched through google and previous forums here with similar problems but none of the answers in those forums seemed to indicate why my code is not working... I have even compared to the example and it is...
  15. M

    Application-defined or object-defined error

    Dear Gents, I've got errornotice for following code: Cells(ActRow, 41).Value = NewUseVol I already define ActRow and NewUseVol(=0) (with public) Would you please suggest any solution to handle this error? Thanks.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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