Re: Scripting Excel X
Re: Scripting Excel X
- Subject: Re: Scripting Excel X
- From: "Eric Phillips" <email@hidden>
- Date: Thu, 09 May 2002 13:04:31 -0400
Thanks Dave for the information. Sorry for the typo, cell(rowcounter,3).Value is correct, my faut for trying to use my brain instead of a piece of paper to remember the code. I will try that offset command which should save me a couple of lines not needing to remake the cellref. I know VB can use both R1C1 and (1,1) style cell references. Since AS can only use R1C1 you need to build the reference before you use it if you are using a variable to designate the cell. With the (1,1) style you can put the variable directly into the reference and be done with it. I just thought of this but I don't think it will work cell("R" & rowcounter &"C3"). I will try it tonight but I think I am still stuck generating the string first. I am rambling now. Thanks for the help.
Eric
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.