run-time error '1004'

I'm using the following code before running my script to help cover any errors, as people sometimes add spaces at the end of titles causing my macro to crash so, before running I was attempting to make sure the sheet - which the name never changes - would be selected before executing to avoid...

I'm trying to use the SEQUENCE formula in the code below but getting a run-time error. Am I missing something in my code? Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Application.ScreenUpdating = False If Not Intersect(Target, Range("startDate")) Is...

Greetings - I'm asking for help resolving the error(s) I get below or finding another solution to my goal. Goal: VBA to get the values from cells 'A1' and 'A2' on 'Sheet2' of the XLFileName workbook (without opening) and assign them to the variables TotColumns and TotRows. My code is...

I wrote a VBA code that was working until a few days ago now I am getting an error message that is can't do that to a merged cell when trying to copy and paste. However, there are no merged cells in the section that is being copied and pasted. Below is the code that keeps throwing the error...

Hi I am having difficulty with a Paste Special line in my VBA and cannot work out why. I have searched various websites and tried a load of different things, without success! The section of code is: Worksheets("Required Data").Activate ActiveCell.Offset(0, 2).Copy detail = ActiveCell.value...

Hi Folks, I have an old excel model last modified in 2010 that was written by a pretty decent VBA / SQL programmer who has since deceased. All our old machines are running Windows 7 professional on a 64 bit OS using 32 bit Excel 2013 (8 gb RAM). A new PC installed recently runs...

Hello All. I have an issue in my loop and I have no idea why it's not working. Can anyone please help me. It's the only thing (so far) holding me back from completing this project. In my Payroll project there is a time, every 2 to 3 years, our Government National Insurance Service (a.k.a. NIS)...

I built macros to automate a sales reporting process. I am leaving the company and trying to ensure the sales report will be usable after I leave. My boss who will be running the report uses a MacBook Air. When I run the macro, the first error that comes up says "Print - Error while printing"...

Hi Gurus, I have a scroll bar (form control). There are cells which are updated based on the scroll bar value. I want to protect the work sheet and I have selected the cells to be protected and have them Locked in format cells --> Protection. When I scroll to next level, below message is...

Hi. I am having an issue with a macro I wrote that reformats a report I receive in Excel. One of the commands looks for the blank cells in column A and based on the content of column C, enters the appropriate value. Frequently, when I run the macro I get "Run-time error '1004'...

I am trying to rung a 'save as file name' macro, and getting the error: Run-time error '1004': Microsoft Excel cannot access the file c:\program files (x86)\microsoft office\office 14\91cd6000. there are several possible reasons: -The file name or path does not exist. -The file is being used by...

I'm trying to loop through my sheets and when I get to the 8th sheet, it has this error: "Run-time error '1004': Select method of Worksheet class failed." Anyone see my mistake? It works great through the first 7 sheets, not sure why it wont continue. My Code is: Sub...

Hi, I have a macro to open files -> copy data from a1:b800 -> put it to general file and doing solver function. But when I'm start a macro I'm get back information "Run-time error '1004': Microsoft Excel cannot paste the data." Frequency of this message is 80% of time when I'm start a macro. I...

Hello everyone! Long time reader first time poster here... I have a macro that pulls data from a table into a pivot table and then sorts it. I use the same process/code 4 times so that I can break up the data into 4 separate pivot tables. The code I use for the first 2 pivot tables works fine...

Here is my code Sub SaveWOWithNewName() Dim strNew As String Dim F5 As Range strNew = "C:\Users\AdminAssist\Dropbox\Work Orders\Work Order Index\@1.xlsm" Application.ScreenUpdating = False With ActiveSheet Set F5 = .Range("F5")...

Have some code that should determine users My Documents path, Create a New Folder in their documents, then save a newly created PDF document in that folder. It runs fine on my system. When other users try to run it, they are getting: Run-time error '1004': Document not saved. The document...

Hello, I am new to posting in this forum and fairly new to Macros/VBA so please excuse me if I miss anything. I created the following long formula that gets me the info I need to create an accounts receivable aging report: =IF(X2="CM", "Credit", IF( X2="PMT", "Unapplied", IF(X2="INV"...

Hello, I am currently trying to make a simple button that filters a PageField in a Pivot table. Worksheets("SN VIEW (2)").PivotTables("SN").PivotFields("DELIVERY SEQUENCE").PivotFilters.Add Type:=xlCaptionContains, Value1:="*ONSITE*" This will give me a Run-time error '1004'...

Hello all, I have been given a macro recorded on a mac and it works fine with Mac Excel 2011. Unfortunately, I need to make it to work on a windows machine, but it comes up with an error message "macro unable to set width property of the window class. Run-time error 1004". When I press debug...

Hello, I am posting this question to the forum after reviewing several other posts trying to find a solution with no success. OS - Windows XP Office version - Office 2010 What the issue is - I have developed an Excel 2010 template with macro's (.xltm) that has some sales data pasted into it...