VB Code to hide rows - ExcelBanter

Posted to microsoft.public.excel.programming

Lonnie M.

external usenet poster

Posts: 184

VB Code to hide rows

Correction:
* Columns(1).EntireColumn.SpecialCells(xlBlanks).Row s.Hidden

Should read:
Columns(1).EntireColumn.SpecialCells(xlBlanks).Row s.Hidden = True

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Macro code to hide rows and not calculate hidden rows	bradmcq	Excel Discussion (Misc queries)	0	September 1st 09 12:38 AM
Enabling option „Format rows“ to hide/unhide rows using VBA-code?	ran58	Excel Discussion (Misc queries)	0	July 28th 09 03:46 PM
Code for Excel 2007 to hide rows based on sum of several rows not ina range	Joe Gardill	Excel Programming	2	August 29th 08 03:53 PM
Code to Hide Rows	BHatMJ	Excel Programming	3	May 24th 07 04:21 PM
Modification in the CODE to HIDE rows and columns that start with ZERO (code given)	Thulasiram[_2_]	Excel Programming	4	September 26th 06 04:15 AM

All times are GMT +1. The time now is 12:41 PM.

Menu

About Us