View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default Insert method of range class failed

Nevermind, please ignore this post. I figured it out: autofilter must be off...

"quartz" wrote:

Could someone please help me out here? I know I'm missing something right in
front of me, but what? The following code line results in "Insert Method of
Range Class Failed":

ActiveSheet.Rows(strRows).EntireRow.Insert Shift:=xlDown

NOTE: the variable "strRows" contains for example may contain:
21:21
or
21:32

Thanks much in advance.