Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default Err.Number 1004 with various Err.Descriptions

I getting an Err.Number of 1004 that can have various, different
Err.Description values.
e.g.
"Microsoft Excel cannot find the data you're searching for. If you are
certain the data exists in the current sheet, check what you typed and try
again."
"Application-defined or object-defined error"
"Copy method of Worksheet class failed"

Doesn't this defeat the object of have a Err.Number somewhat, as you then
have to check the Err.description anyway ?

NickHK


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Err.Number 1004 with various Err.Descriptions

I guess it would be a matter of perspective.

--
Regards,
Tom Ogilvy


"Nick Cranham" wrote in message
...
I getting an Err.Number of 1004 that can have various, different
Err.Description values.
e.g.
"Microsoft Excel cannot find the data you're searching for. If you are
certain the data exists in the current sheet, check what you typed and try
again."
"Application-defined or object-defined error"
"Copy method of Worksheet class failed"

Doesn't this defeat the object of have a Err.Number somewhat, as you then
have to check the Err.description anyway ?

NickHK




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Combine Descriptions BeckyB Excel Discussion (Misc queries) 0 April 6th 10 10:05 PM
Add-in Descriptions James Excel Discussion (Misc queries) 7 July 12th 08 12:28 AM
Translate from Numbers to Descriptions Joey Excel Discussion (Misc queries) 3 April 9th 08 08:33 PM
link colors to descriptions in bar charts mac Charts and Charting in Excel 4 May 18th 07 08:16 AM
IF and OR functions to obtain text descriptions Terranoman Excel Worksheet Functions 1 November 10th 06 09:07 AM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"