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?
|