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: 2
Default programming cell autofit doesn't work?

I have developed a small data entry system to make my bosses' secretary life
easier. The proble is when she print out what are the current jobs for the
IT dprt, (2 of us), I cannot get excel to autofit cells in specifi rows.

The rows for some reason hide the last line of the content of the cells
whose content need to be readable.

Here I select an entire row and apply Autofit to each cell on that row, but
it doesn't work
(curRow is avariable that holds the Current Row No)

Range("E" & curRow & ":" & "G" & curRow).Select
With Selection
.VerticalAlignment = xlTop
.HorizontalAlignment = xlLeft
.WrapText = True
.Rows.AutoFit
End With

Any idea would be greatly appreciated.

TIA all

Philippe


 
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
Autofit row doesnt always work FJ Excel Discussion (Misc queries) 2 February 28th 09 01:19 AM
Autofit (Columns.EntireColumn.AutoFit) does not work Michiel via OfficeKB.com Excel Discussion (Misc queries) 3 February 10th 09 05:29 PM
Autofit does not work when cell is updated automatically. SummerGuy Excel Discussion (Misc queries) 2 February 17th 07 04:28 PM
Autofit doesn't work Rosemary Excel Discussion (Misc queries) 1 October 6th 06 04:21 AM
The Row Height Autofit command does not work. rstrefry Excel Worksheet Functions 4 July 19th 06 05:20 PM


All times are GMT +1. The time now is 12:20 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"