Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "Mika Oukka" wrote in message ... Hello Erik, How about if you remove the label temporarily before autofitting: Range("B1:D1").Select 'Assumed LabelRow = 1 For Each cell In Selection OrigLabel = Cells(1, cell.Column).Value Cells(1, cell.Column).Value = "" Columns(cell.Column).EntireColumn.AutoFit Cells(1, cell.Column).Value = OrigLabel Next Mika Oukka Mika, Yes it works, however if the label is wider than the autofit has allowed for I run into the same problem restoring the label. Erik |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for formatting rows and columns minimizing the outcome. | Excel Discussion (Misc queries) | |||
How to calculate with formula results after formatting with =TEXT | Excel Worksheet Functions | |||
Deleting Columns - Formula Results turn to #REF! | Excel Discussion (Misc queries) | |||
Formatting the Results of VLOOKUP | Excel Worksheet Functions | |||
Formatting zero results from a formula | Excel Programming |