The Origin Forum

The Origin Forum

All Forums

Origin Forum

Sheet name

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Format Mode:

Format:

Message:

* HTML is OFF
* Forum Code is ON

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
dimidola	Posted - 03/11/2011 : 11:30:59 AM Origin Ver. and Service Release (Select Help-->About Origin): 8.0724 Operating System: Win7 Hi, I am trying to create a sheet where I can copy the data from another sheet. The copied sheet is found in a different folder and it is renamed (from the predefined Sheet1) to the name of the txt file I import. So, I would expect my code to be: range a = [Book3]a030!Col(c); range b = [Book10]Sheet1!Col(b); b = a a030 is the name of the copied sheet. however this doesn't work! if I rename the sheet back to Sheet1 it works!!! any thoughts??? also, is there a way to only copy the first 10 rows of the column??? thanks a million
3 L A T E S T R E P L I E S (Newest First)
greg	Posted - 03/17/2011 : 10:07:03 AM FYI : Subranges did not work in your version, but do work in 8.5: range a = [Book3]a030!Col(c)[5:20]; range b = [Book10]Sheet1!Col(b)[10:25]; b = a;
dimidola	Posted - 03/17/2011 : 04:07:54 AM the copying works! thanks! however I get all rows copied :(
cpyang	Posted - 03/13/2011 : 08:13:21 AM If there is only one sheet, then use index might solve the problem. range a = [Book3]1!Col(c)[1:10];//1st 10 rows range b = [Book10]1!Col(b); b = a CP

The Origin Forum