• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Adding a row to Excel
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Adding a row to Excel


  • Subject: Re: Adding a row to Excel
  • From: Deivy Petrescu via AppleScript-Users <email@hidden>
  • Date: Mon, 14 Dec 2020 10:53:59 -0500


> On Dec 14, 2020, at 10:47, Jeremy Roussak via AppleScript-Users
> <email@hidden> wrote:
>
> This is, I’m sure, very simple but as I’ve never tried to script Excel
> before, I’m struggling.
>
> I have a small Excel document with a solid block of numbers, 8 columns by a
> few rows. I want to add a row to the bottom of that block. How do I find the
> number of the current last row? Is there an easy way to make another row at
> the end? I’ve looked at “used range”, which it seems should be the way to go,
> but I get stuck.
>
> A few of the cells will have a formula, if that makes any difference.
>
> Any help gratefully received.
>
> Jeremy
>
>
> Jeremy Roussak
> Photography: jbr.is
>


Hello Jeremy,

It has been a while since I’ve scripted Excel, but looking at some old scripts,
I found this:

set lastLine to row of (get end of range thRange direction toward the bottom)

So it shows correctly, it means it is still working.


Best, be safe and wear mask.

Deivy Petrescu
email@hidden






 _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden

References: 
 >Adding a row to Excel (From: Jeremy Roussak via AppleScript-Users <email@hidden>)

  • Prev by Date: Adding a row to Excel
  • Previous by thread: Adding a row to Excel
  • Index(es):
    • Date
    • Thread