Thom
06-09-2008, 07:23 AM
Hello all.
In the sheet I'm creating, I have a lot of data, so I've put the address all in one cell with the top line size 12 and the rest of the lines size 8 (they aren't as important).
However when I go to print it, the bottom is cut off. If I remove the fontsize formatting, it works fine.
So basically i want to get the current rowheight and just had a lilttle bit more on. But my code doesn't seem to want to do it.
Range("A1:Q" & (LastRow)).Select
With Selection
.RowHeight = 35
End With
That works as it should (set all the rows to 35).
But I want it to add say 5 more pixels.
I have tried
Range("A1:Q" & (LastRow)).Select
With Selection
.RowHeight = .RowHeight * 2
End With
I got this off the msdn but it does not work, nothing happens.
Any ideas?
In the sheet I'm creating, I have a lot of data, so I've put the address all in one cell with the top line size 12 and the rest of the lines size 8 (they aren't as important).
However when I go to print it, the bottom is cut off. If I remove the fontsize formatting, it works fine.
So basically i want to get the current rowheight and just had a lilttle bit more on. But my code doesn't seem to want to do it.
Range("A1:Q" & (LastRow)).Select
With Selection
.RowHeight = 35
End With
That works as it should (set all the rows to 35).
But I want it to add say 5 more pixels.
I have tried
Range("A1:Q" & (LastRow)).Select
With Selection
.RowHeight = .RowHeight * 2
End With
I got this off the msdn but it does not work, nothing happens.
Any ideas?