Posted to microsoft.public.excel.programming

Darin Kramer Darin Kramer is offline

external usenet poster

Posts: 397

Alternative way to refer to a row to hide or unhide...

Hi There,

I currently have a simple VB that selects data in row 60 and 61 (see
below). Problem is that if a user adds lines (and its quite possible
that he may) the macro will not hide the correct row. Is there VB to
hide a named range...?

Kind regards

Darin

Rows("60:61").Select
Selection.EntireRow.Hidden = True

*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Hide/Unhide row VBA	Scafidel[_2_]	Excel Discussion (Misc queries)	1	March 23rd 09 05:28 PM
hide/unhide	brownti	Excel Discussion (Misc queries)	3	February 6th 07 07:14 PM
Hide Unhide	Colin	Excel Discussion (Misc queries)	4	April 9th 06 05:01 PM
Hide/unhide	Jock W	Excel Worksheet Functions	4	October 4th 05 05:02 PM
hide/unhide	heartbreakkid	Excel Programming	6	May 7th 04 10:13 PM

All times are GMT +1. The time now is 05:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us