1004 error

Hi all, I am using Excel 2013 to build a production schedule, with the main schedule located on a worksheet called "Schedule" and a production template for each job on a worksheet called "Template." The job information is in the first few columns, then each column represents a week. When a...

i have below macro which i recorded in windows and working perfectly fine. But when my client is trying to use it from MAC, it doesnt work. Showing error message "Run-time error "1004" Aplication defined or obeject defined error". Please let me know why this is happening and what can i do to...

When I ran my maco I received a Run-time 1004 error: Application-defined or object-defined error. Do you know what is causing this error/ how to fix it?

Hi, Please help me with this. I keep on getting application/ object not defined error messages. I have no idea how to fix it, as I dont know what I did wrong. Thanks. Best, Morris Here is my code: Dim wb As Workbook Application.ScreenUpdating = False Set wb =...

<!-- BEGIN TEMPLATE: ad_showthread_firstpost_start --><!-- END TEMPLATE: ad_showthread_firstpost_start -->Here I am getting it: For Each cell In Range(temp(0).Cells(1).Offset(0, 1), Cells.SpecialCells(xlCellTypeLastCell)).SpecialCells(xlCellTypeConstants, 1)

Newby here. Please be gentle! When I run my excel macro and keep the cursor in the workbook that the macro is running in, the macro is able to set the cursor position to where I need it. I use: Workbooks("TwsDdeNick_prod.xlsm").Worksheets("BasicOrders").Range("A10").Activate Now, when I...

I'm trying to change the SQL query in my pivot table, with a macro, but I'm getting a 1004 "Application-defined or object-defined error" with the following code: Private Sub cmndRefresh_Click() Dim strSQL1 As String Dim strXSTreaty As String 'Setting Variable value based on XS Treaty...

First off apologies for the unsightly formulae below - I'm not sure how I can make them easier to read without potentially removing required info for a solution. I'm trying to automate some analysis in Excel, and am getting run time error 1004 each time I try to step through the vba to...

Okay...I am trying add a script to load the jpg image on a cell next to it. I am getting a 1004 error List of urls is in column A1:A3 Sub b() Dim cell, shp As Shape, target As Range myurl = "http://abc.com/efg.jog Photos/Profile Pictures/corp_clao_MThumb.jpg" Set Rng =...