LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luc Luc is offline
external usenet poster
 
Posts: 23
Default Setting row height to 0 in the visible celss of a range


Hello there,


-I have a range of cells named "All"
-This range consists of a part of a column (for example A30-A1000)
-Depending on some paramaters not all of the rows of the range "All" are
visible (example : A40 to A55, A120 to A141 ,,, A750 to A766 are visible).
-I want to change the row height of the visible cells in the range "All"
which are empty to 0 row height (in fact hidden).
-Can someone provide me some code to do this


Thanks,

Luc




 
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
setting row height not to exceed... Tina Excel Discussion (Misc queries) 1 April 6th 11 07:22 PM
Setting visible range ZipCurs Excel Programming 2 January 5th 06 03:43 AM
Help finding error setting range to Visible Cells Ed Excel Programming 3 January 26th 05 06:11 PM
setting the auto row height using vba Lucky[_4_] Excel Programming 3 April 9th 04 06:10 PM
Setting width and height Tom Egan Excel Programming 0 February 5th 04 03:35 PM


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