> From: Beckett Richard-qswi266 [mailto:[EMAIL PROTECTED] > Subject: Win32-OLE excel cell reference.
> It seems that the Range command likes data like (A14), or > (A14:B26), and I am happy with this. > > My problem occurrs when I only have numeric data to work > with, because of incremented counters, or Count commands. > > I have had success with Cells(1,14), but I cannot for the > life of me work out how to reference an area of cells like this... > > Cells(1,14:5,28) You have to use the range and cells object together, like so: <code> $Sheet1->Range($Sheet1->Cells(1,14), $Sheet1->Cells(5,28))->Select(); </code> Chuck Charbeneau Lear Corporation Lead Software Applications Engineer ccharbeneau at lear dot com ********************** ** LEGAL DISCLAIMER ** ********************** This E-mail message and any attachments may contain legally privileged, confidential or proprietary information. If you are not the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this E-mail message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this E-mail message from your computer. _______________________________________________ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
