ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Insert method of range class failed (https://www.excelbanter.com/excel-programming/307244-re-insert-method-range-class-failed.html)

quartz[_2_]

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.



All times are GMT +1. The time now is 12:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com