Macro that can draw borders in cells with data across multiple sheets in a workbook

Hello;

What I need is a macro that can draw borders in cells with data across multiple sheets in a workbook. I already have the following code that almost can do it:

Please Login or Register  to view this content.

The problem I have is that it does not find the last row in all the sheets. What it does instead is that it finds the last row in the sheet that I run the macro from, and then It will use the value of the last row in this specific sheet in all other sheets. So for instance, if I run the code from sheet 3 that has 72 rows with data, It will draw tables (borders) with 72 rows in all my sheets, even though the number of rows with data in the different sheets are not similar.

Please Login or Register  to view this content.

Should be

Please Login or Register  to view this content.

Thank you very much AB33.

Is it possible to further develop the code, such that it also finds the last column to draw a border on automatically, rather than having it drawing borders until column h all the time??

Please Login or Register  to view this content.

Nice. Thank you