Your sheet is loaded with "Merge & Center" cells. Accidents waiting to happen. Get rid of them and use "Center across Selection" instead. (Google it and you'll see what the experts think of it.)
There are different ways to calculate your last used Column and Row.
In your attachment you dont want to print up to the laste used Column because that is Column R which is used for the conversions.
It looks like the best way would be to find the Column in row 24.
If so, the last column could be calculated with
If it needs to be another row, change the 24 to the row number that suit your needs the best. (NOT merged cells)
If you have the conversion table in another sheet or all to the left of your print area, following would be the best way.
For your last used row, it looks like there will always be data in Column A so the last used row is calculates as
If there is never going to be anything below the area to be printed, you can use this also
So your PrintArea would be like
or equivalent.
BTW. 20 meters is not 6.1 ft. The other way around is closer to the truth.
Bookmarks