All Forums  Origin Forum for Programming  LabTalk Forum  Using range variable to access wks methods

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

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by duffy01[/i] [br]Origin Ver. : 8.5.0G SR1 Operating System: Win 7 Hi, sorry for the maybe dumb question but this problem drives me crazy since some time within different circumstances. I read Helpfiles a lot but don`t get it and I want to understand now. Basic Idea is, to work between columns in different worksheets, maybe also in different Workbooks. Since I want to reuse the scripts for different purposes, I want to be able to just change Worksheetnames (Sometimes also Workbooknames and Columnnames) only in the headerin order to make the script work. My way is to setup a two range variables for both sheets, e.g: range aWks=!; range eWks=[Book1]Ergebnis!; typically I want to reference on a certain column using xfuncionts etc. In many cases I am able to do that via substitution notation, but I almost always have to try several times to find out which is the correct way, and sometimes I am not able. Let`s give an example: I want to start by inserting a noew column in eWks: eWks.insert (new); // works But since I want to assure, that it is inserted as second column I would like to take care about it via Labtalk before. So I insert something like this before: eWks.col=2; // Doesn't work, because Origin seems always to use the activated Worksheet as reference. Same accounts, when I try to change values of user parameters. But it works fine using the above mentioned notation, when I try to change type of col… eg: eWks.col2.type=4; // Works Could somebody explain me what I do not understand in the progamming concept or give me a short code example, which explains this, without changing the active Workbook? Thanks in a advance Martin [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.