Posted to microsoft.public.excel.programming

bg18461[_12_] bg18461[_12_] is offline

external usenet poster

Posts: 1

hiding rows on worksheets

When I use:
Worksheets("JAN").Range("7:7,29:29,53:53").EntireR ow.Hidden= True

or

Sheets("JAN").Range("7:7,29:29,53:53").Select
Selection.EntireRow.Hidden = True

I now get the error:
'Select method of Range class failed'

Any other suggestions

--
bg1846
-----------------------------------------------------------------------
bg18461's Profile: http://www.excelforum.com/member.php...nfo&userid=887
View this thread: http://www.excelforum.com/showthread.php?threadid=31513

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
Color alternate rows when after hiding selected rows	Monk[_2_]	Excel Worksheet Functions	6	June 7th 08 01:36 AM
Hiding Specific Rows Based on Values in Other Rows	Chris	Excel Worksheet Functions	1	November 2nd 06 08:21 PM
Hiding a button when hiding rows	fergusor	Excel Discussion (Misc queries)	2	August 10th 06 02:31 PM
HIDING ROWS IN PROTECTED WORKSHEETS	kyoung	Excel Discussion (Misc queries)	2	June 9th 05 05:17 AM
hiding rows on worksheets	bg18461[_11_]	Excel Programming	2	November 18th 04 09:53 PM

All times are GMT +1. The time now is 02:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us