Last used row between row 25 to 125

[excellearner121]

Hi all,

any help would be much appreciated. I was wondering what code should i use to return the last used row from row number 25 to row 125. i have data after row 125 which cannot be moved.

Thanks,
A lot.

[WasWodge]

Try...

Please Login or Register  to view this content.

[excellearner121]

Thanks a lot WasWodge for the reply. sorry i missed another bit of the question. below is the code that i am using. the column to look in for last row is B. as there will always be data in column A and other columns. Thanks a lot once again. .

Please Login or Register  to view this content.

[WasWodge]

Untested as on my phone now.

Please Login or Register  to view this content.

[excellearner121]

Thanks a lot WasWodge. it did the trick. Appreciate your help!