LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default formatting columns with formula results


"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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for formatting rows and columns minimizing the outcome. urlocaljeweler Excel Discussion (Misc queries) 1 December 9th 09 05:24 PM
How to calculate with formula results after formatting with =TEXT VickiMc Excel Worksheet Functions 3 September 21st 09 10:27 PM
Deleting Columns - Formula Results turn to #REF! Havenstar Excel Discussion (Misc queries) 10 December 28th 06 09:31 PM
Formatting the Results of VLOOKUP LPS Excel Worksheet Functions 1 February 11th 05 02:15 PM
Formatting zero results from a formula CiaraG[_2_] Excel Programming 1 August 19th 03 04:24 PM


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"