1004

Ok, this seems like it should be the easiest thing in the world, but there is obviously something critical that I'm missing. I've done a search of the forum but can't seem to find a similar issue. I'm writing a longer routine, but am running into an issue with filling the cell color. It...

I am suddenly getting the same error on my own Excel 2003 code, which has been unchanged and working for the past 2 years now. I am also getting the "Not enough system resources to display completely" message just prior, but I am not certain that it is related. This particular user also...

I have a workbook / macro that no longer works since I moved to Excel 2007. When running some code that hides / unhides rows it gives me The offending line of code is Rows("35:40").Hidden = True Now, I thought this may be due to the worksheet being protected; however I do have the code...

heloo people - I need to copy seeral thousand records from a windows programme into excel. Unfortunately, the program does not allow me to select all of the records at once, only one row at a time. However, I can select the top row, copy the contents with Ctrl+c, move down a row with the down...

Hello, The following statement in my little VBA program produces the "Run-time error '1004': Application-defined or object-defined error": Worksheets("calc_base(DO NOT DELETE)").Range(Cells(MW, 2), Cells(MW, 2).End(xlToRight)).Copy Destination:=Worksheets("Projekte").Cells(INPUT_ROW...

Hi all, First post here. I'm getting '1004' on this instruction: Selection.Formula = ConcFormula ConcFormula is a String which has: =CONCATENATE("(select ";$B$6;" from ";$B$2;" where ";$B$3;" = ";"'";$B$4;"' AND ";$C$3;" = ";"'";$C$4;"'";")") The desired result is an SQL Select statement...

I am trying to build a macro to be placed in a blank spreadsheet for use as a template. My development platform is Excel 2003 on Windows XP SP2. The script was initially recorded as a macro against a single data file with absolute range references and worked both on my develpment platform and on...

Hello, I came across a problem with my macro and decided to record a macro and see how excel did this, the result: Range("G14,I14").Select Range("I14").Activate ActiveSheet.Shapes.AddChart.Select however, when I run this macro i get the 1004 error on the last line?! The last...

I have the strangest problem. :confused: I have an excel form. A lot of different validations, VBA code and stuff. hverything works, however, i am stock on the easiest thing, that appears to be a bug in Excel. I am trying to protect a sheet. I specified which cells to be unprotected. However...

Here's what I'm doing... I have a combo box (called ClientListBox) that displays 2 columns, Column A (which is a unique id) & Column B (client's name) when they select the item, the click event should populate all the fields on the user form. Here's the code: Private Sub ClientComboBox_Change()...

I am having trouble with IsError function consistently catching errors in my call to the Search worksheetfunction. For example, here is a snippet of my code that works just fine: If IsError(Application.WorksheetFunction.Search("__*-DEFERRED", netName)) Then If...

I have a VBA module for which the ultimate goal is to write an Excel file into a specific folder. That folder resides on a networked shared drive and has controlled access via the user's LAN ID. So that the file is not lost in the event that a user is not authorized to read or write to the...

We are moving from Excel 2003 to 2007 and we have a report that reads from another spreadsheet. It still runs fine in 03 but in 07 we get the following error Run-Time Error '1004' The information cannot be pasted because the Copy area and the paste are are not the same size and shape...