Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
fexxor
Posted - 03/15/2009 : 5:36:19 PM Origin 8 Ver. and Service Release 4
After computing several datasets, call them ds1,ds2, etc, I want to put these dataset (save them ) into the appropriate worksheet column, say col(3), col(4), etc. I know the range of the entire worksheet call it rr. How can I do this?
Is there a way of specifying the columns of the worksheet in range notation without having to define a different range for every column?
Thanks for any clarification.
1 L A T E S T R E P L I E S (Newest First)
greg
Posted - 03/23/2009 : 11:38:46 AM There isn't a shortcut notation that gets a range as a string for use in declaring a new range so you have to construct the string from it's parts.
string strBk$ = rr.GetPage()$; // Get the Book referenced by 'rr' string strSh$ = rr.name$; // Get the Sheet referenced by 'rr'
Then you can use these parts to declare new ranges and if need be use variables in the declaration such as:
loop(ii,1,5) { range rTemp = [strBook$]strSheet$!$(ii); // Re-declare range rTemp to use the next column rTemp = ds$(ii); // copy dsN to next column }