Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default (Un)usual "cannot set Xvalues" error message

ARRRGGGHHH!!!

RTFM.

I suspected this but the helpfile confirmed it:

Ranges must contain data when passed to a series. When I read that I
suddenly remembered about a line of code I'd got tucked away that
cleaned up prior to any calculations. At least, it was supposed to be
prior...

Wierdly it was the Y-values that were dataless. I had moved the "write
the data" code to occur before the "reset the worksheet" code.
Basically I was writing the data then deleting it, then trying to graph
it.

Error 1004.

The odd thing was that it was occuring at the .Xvalues point and not
the .Values point, where the error actually was. This is what sent me
off down the wrong path. However, when I moved the code around the
error was solved, so that must have been the reason.. The 95%
confidence interval data was not affected in this way since it has a
separate clean-up procedure.

If this helps anyone all the better I suppose :o) This is important to
watch for because the two chunks of code were in entirely separate
subroutines (they are now combined in one) which made troubleshooting
all that more difficult. Sometimes object-oriented programming isn't
the best way to go ;-)

Cheers

Bennett

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
Pivot Table Error Message - "too many records" Excel 2007 MAK Excel Discussion (Misc queries) 0 November 5th 08 09:19 PM
"Unable to Read File" error message in Excel - solutions? Presby Loaner Excel Discussion (Misc queries) 2 June 27th 07 05:09 PM
How do I ignore the "Number stored as text" error message permane. reston33 Excel Discussion (Misc queries) 2 March 28th 07 02:59 AM
Deleted the pivot table - continue to get the "overlap" error message [email protected] Excel Discussion (Misc queries) 0 September 27th 06 04:07 PM
"GoalSeek method of Range object failed" error message Fixit_Steve Excel Programming 0 January 13th 05 07:29 PM


All times are GMT +1. The time now is 03:41 AM.

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"