Posted to microsoft.public.excel.programming

Janis

external usenet poster

Posts: 360

runtime error

I got a type mismatch run-time error on the line to set the range.
I just want to hide columns 0 - Z or columns 16-26.
Can you help me set the range right?
thanks,

Sub HideXtraCells()
Dim rng As Range
' HideCells Macro

Set rng = Columns("0:Z")

rng.EntireColumn.Hidden = True

End Sub

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
xpath error? Runtime Error 13 type mismatch	Steve M[_2_]	Excel Discussion (Misc queries)	0	January 17th 08 01:16 AM
xpath error? Runtime Error 13 type mismatch	SteveM	Excel Discussion (Misc queries)	1	December 4th 07 09:16 AM
Excel 2003 Macro Error - Runtime error 1004	Cow	Excel Discussion (Misc queries)	2	June 7th 05 01:40 PM
Syntax Error Runtime Error '424' Object Required	sjenks183	Excel Programming	1	January 23rd 04 09:25 AM
Unknown where is the problem on the Runtime error - Automation error	wellie	Excel Programming	1	July 10th 03 08:12 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us