Is it possible to autofit a row and then add "10" to the new height?
Example:
If autofit set the row height to "15" I would want to change the row height adding "10" (25 total).
Autofit would have to be first.
Is it possible to autofit a row and then add "10" to the new height?
Example:
If autofit set the row height to "15" I would want to change the row height adding "10" (25 total).
Autofit would have to be first.
Last edited by Rick_Stanich; 07-08-2009 at 10:13 AM.
Regards
Rick
Win10, Office 365
Sub X() Dim rngRow As Range Selection.EntireRow.AutoFit For Each rngRow In Selection.Rows rngRow.EntireRow.RowHeight = rngRow.EntireRow.RowHeight + 10 Next End Sub
As in:
for example?With ActiveCell.EntireRow .AutoFit .RowHeight = .RowHeight + 10 End With
Everyone who confuses correlation and causation ends up dead.
Sometimes, I just dont think.
Thank you both.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks