I thought Append Range would append the data from the copied data to the first blank cell/row of the intended sheet. However, it is pasting the data around row 800 instead of row 40. What’s the secret to have the append range start after the last line of existing data in the pasting sheet? Thanks

@RPANovice1 , You can use delete range activity for this

Append Range - First Blank row

J0ska February 18, 2025, 6:52pm 8

Attached workflow contains code that will shrink the “UsedRange”
ShrinkRange.xaml (12.2 KB)

Cheers

Topic		Replies	Views
How to append range in the first blank row? Academy Feedback	2	2716	March 13, 2020
Excel Append range missunderstandings Studio studio , question , activities_panel	6	402	December 1, 2023
Excel Append Range, does not append at first blank row Help	1	1889	May 16, 2020
I would like the bot to write to the last empty line in Excel Forum question	23	2400	March 15, 2022
Issue with Append Rage StudioX studiox , question	9	449	July 9, 2023