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: 20
Default Hiding rows where text not entered to right of colums A and B

I have a worksheet with narrative from A11:B60. Can someone provide me with a
macro that scans down rows 11 to 60 and if there is no content to the right
of columns A and B it hides these rows. i would still need to see the
headings for all the columns which stretch across to Column AD

Thanks in advance,


Aidan.
 
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
Hiding colums when saving as html Big-dog1965 Excel Discussion (Misc queries) 4 March 25th 08 04:42 AM
HIDING ROWS AND COLUMS Doo0592 Excel Programming 15 September 5th 06 10:56 AM
How to separate names that are entered in 1 column into 2 colums Paula Excel Discussion (Misc queries) 2 May 18th 06 05:45 PM
Can I rearrange data entered in rows into colums in Excel? Robin Excel Discussion (Misc queries) 1 January 30th 06 07:48 PM
Excel will not show all text entered in a Cell merged from 9 rows Pat Excel Discussion (Misc queries) 6 August 18th 05 11:14 PM


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