Posted to microsoft.public.excel.programming

mrbarritt

external usenet poster

Posts: 4

Certain methods, such as Cells.EntireRow.Hidden, stop VBA subrouti

I have been noticing that when using VBA in Excel, certain methods can cause
the termination of a subroutine without any warning. Some of these a

Cells.EntireRow.Hidden
Range("O3:AQ3").MergeCells = False
Columns("AD").Insert Shift:=xlToRight, CopyOrigin:=Null

Has anyone else had a similiar experience or know why?

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
Can't set the Entirerow.Hidden property.	Jeremy	Excel Programming	3	March 21st 07 04:52 PM
Macros cells.EntireRow.Hidden = True and Range.Sort are stopping	Adrian	Excel Programming	0	March 22nd 06 01:59 AM
Entirerow.delete based on multiple cells	tom[_7_]	Excel Programming	5	December 15th 05 09:25 PM
Hidden workbook properties/methods	R Avery[_2_]	Excel Programming	1	May 23rd 05 07:33 PM
EntireRow.Hidden	Jonas Haettner	Excel Programming	1	October 24th 03 09:19 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us