| T O P I C R E V I E W |
| origjuhu |
Posted - 08/28/2010 : 1:31:17 PM
Origin Ver. and Service Release (Select Help-->About Origin): 8.1 SR3 8.1.34.90
Operating System: Windows 7
Hi,
i got a set os several worksheets 2 columns each. I want to combine all these worksheets into one. I tried to use the wks.join() function as described in
http://www.originlab.com/www/support/resultstech.aspx?language=english&ID=926
wks.joinMode=0
Sheet1!wks.join(Sheet2);
but it just does not work. no error. it just does not join any data.
Any ideas on what i am doing wrong?
|
| 2 L A T E S T R E P L I E S (Newest First) |
| origjuhu |
Posted - 08/30/2010 : 3:16:17 PM
Hi Laurie,
thanks for your quick response. The magic ! missing on mit Sheet2 in the brackets.
now everything works just fine! Thank you! |
| Laurie |
Posted - 08/30/2010 : 12:19:31 PM
Assuming sheet1 is active, and sheet1 and sheet2 are in the same workbook,you can just use the following:
wks.join(sheet2!);
Otherwise, you'd need a longer notation:
range rInWks = [book1]sheet1!;
rInWks.join([book2]sheet1!);
OriginLab Technical Support |
