Posted to microsoft.public.excel.programming

Nde

external usenet poster

Posts: 16

Error 1004 - Application-defined or Object-defined error

Hi,

I do have a 1004 error using the following code. Any Sggestion...I use
similar code in an other macro and it works fine.

ActualToReport = "=SUMIF('Actuels Finance PUID'!C1,''" + ActiveCell.Value +
"'','Actuels Finance PUID'!C" + Trim(Str(ColumnCounter - 2)) + ")"

Worksheets("ReForecast - Detailed").Cells(CurrentRow, ColumnCounter).Formula
= ActualToReport

Thanks,
nde

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Runtime Error 1004: Application defined or object defined error	Access n00b	Excel Programming	2	April 5th 06 02:58 AM
Run Time Error 1004 - Application-defined or object-defined error	brent	Excel Programming	2	October 3rd 05 05:23 PM
Run-time Error 1004: Application-defined or Object-defined Error	Adrian	Excel Programming	6	August 23rd 05 06:28 AM
Macro Run-time Error 1004 Application Defined or Object Defined Error	Anddmx	Excel Programming	6	June 9th 04 03:40 PM

All times are GMT +1. The time now is 08:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us