![]() What actually happens for me is that Excel selects the used cells of row 3 AND the last row with data rather than row 3 THROUGH the last row with data, ie only the two rows specified and not the intermediate rows. I ended up with that line after much experimenting with terms such as from, to, :, including, containing, etc. The ranges after the select command is what AppleScript puts in if I use range. Select (ranges (row 3 of used range of the active sheet) thru (last row of used range of the active sheet)) The following part of the script (which assumes an open worksheet with data) is where I am getting frustrated: ![]() ![]() When it comes to selecting the rows I wish to use, I am getting an incorrect result from what appears to be the correct command. Opening the files is working OK with no problems. The first two rows contain header information which I would like to leave in place. The background is this - I am working on a script to open text files containing two columns of data and a varying number (about 50 to 170) of rows of data, select the data in the third row down to the last row, and then make a chart from that data. I am having some trouble with AppleScripting in Microsoft Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |