Last row on every page

[tqm1]

Dear Sir,

How to findout LastRow on every page in sheet.

http://www.vbaexpress.com/forum/showthread.php?t=13260

Actually I want to apply following border to lastrow of every sheet page

Please Login or Register  to view this content.

Please help

[mudraker]

Here is several ways to find the last used row & column

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[VBA Noob]

Hope this i not another cross post ??

Also if you want to post here please reply to your other posts.


The below will run on the last cell in Col A for each sht which may not be what you want

Could try usedrange...see link

http://www.rondebruin.nl/last.htm#one

Please Login or Register  to view this content.

VBA Noob

[VBA Noob]

tqm1 ,

Thinks for agreeing to folow the rules. I've posted the cross link for you

http://www.vbaexpress.com/forum/showthread.php?t=13260

VBA Noob