Get First Free Row In a Table When The Table Has Empty Rows Above The Table

[UK_Mike]

Hi All,

More often than not data or a data table starts at A1.

There are occasions where this data has empty rows above for whatever reason.

So lets assume my data starts at A5, how do I get the first free row in this range ?

Thanks, Mike.

[UK_Mike · Accepted solution]

Hmmmmmmmmmmmmm,

I think I figured it out, read range which gets me all the data.

In the data table I have the last row which gives me what I wanted.

LOL 😂

[MichaelAnnis]

Just for future reference, FirstFreeRow, in my experience, is the same as you pressing Control + End and then it just gives the next row from the active cell. So it should still work in this scenario. 

[UK_Mike]

Jaysus !!! I always thought that only worked when inside the range 🙄

I will stick with the read range so I can store the result for later use in the flow but good to know.

Cheers Mike.

Unfortunately Ive already marked myself as solution 😂

[MichaelAnnis]

No worries. I found that out the hard way. Because clearing contents doesn’t change the End row, you have to physically delete the blank rows at the bottom, click in the normal range, and save to reset the End row.