Posted to microsoft.public.excel.programming

David

external usenet poster

Posts: 1,560

Hide range

Hi
Can anybody please tell me what am I doing wrong here
Trying to hide certain rows
Sub aa()
Dim Rw As Integer
Dim EndRw As Integer
Rw = 100
EndRw = 65536
Rows(Rw & ":" & EndRw).Hidden = True
End Sub

Regards

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 range	Jim Thomlinson	Excel Programming	0	April 17th 06 09:30 PM
Hide Range of Cells	[email protected]	Excel Programming	1	February 10th 06 08:30 PM
How to hide a Range of Columns?	scrap08[_2_]	Excel Programming	0	June 29th 04 12:51 PM
hide / unhide range	goss[_24_]	Excel Programming	2	June 21st 04 12:17 PM
How to hide row range from code?	Majstor	Excel Programming	8	November 4th 03 03:50 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us