Posted to microsoft.public.excel.programming

Daniel

external usenet poster

Posts: 354

Runtime error 1004

Hi all,
Have anyone experienced the following situation in VBA.

Run time error:1004
Application-defined / object-defined error

while run at the statement,
dim DataSheet as worksheet
Set DataSheet = ThisWorkbook.Sheets("Data")
strPName = DataSheet.Cells.Offset(intRow, intCol)

Have any ideas?
Any help will be appreciated.

Rgrds,
Daniel

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'	[email protected]	Excel Discussion (Misc queries)	2	July 18th 05 06:10 AM
Excel 2003 Macro Error - Runtime error 1004	Cow	Excel Discussion (Misc queries)	2	June 7th 05 01:40 PM
Runtime error 1004	Ajit	Excel Programming	2	January 13th 05 02:55 PM
runtime error 1004	marta	Excel Programming	0	July 22nd 04 02:25 PM
Why I got this 1004 runtime error	Rob Bovey	Excel Programming	0	July 14th 04 10:26 PM

All times are GMT +1. The time now is 07:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us