Answered

Loop through Excel Rows from Bottom to Top

(0) Share

Report

Posted on by Sudenga_Steve

Loops normally progress from top to bottom through a range of rows in Excel. In my case, I need to loop from bottom up through my rows. This is because I have PAD deleting certain rows and once a row is deleted in Excel, the data moves up. When the data moves up, the row that slides into the deleted row's place gets skipped. I know how to do this in VBA, but any idea how to construct your loop to run from bottom to top in PAD?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Sudenga_Steve 7 on at

Like (0)

Report
Copy link

Link copied!

Folks, I was able to answer my own question. It was as easy as setting the variable CurrentItem = CurrentItem - 1.

Was this reply helpful? Yes No
jen2023 2 on at

Like (0)

Report
Copy link

Link copied!

Hi there @Sudenga_Steve - if you happen to read this, would you mind specifying what your final solution looked like? I am looking to achieve the exact same thing but still couldn't figure it out by myself. Thank you.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (1)

Report
Copy link

Link copied!

Instead of using a for each, I would use a loop, and then LoopIndex would be what row. You are analyzing.

get first free row

Set variable %LoopMax% to %FirstFreeRow - 1%
Loop %LoopMax% to 2 increment -1

with this method you have created a for each from your last row back to row 2. And you can always reference the current row being worked on with %LoopIndex%

good luck!

Was this reply helpful? Yes No