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