Re: Adding a row to Excel
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