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/307242-insert-method-range-class-failed.html)

djh

Insert method of range class failed
 
Sub Macro2()

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

End Sub


-----Original Message-----
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:32 PM.

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