Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofill method of range class failed | Excel Discussion (Misc queries) | |||
Autofill method of range class failed | Excel Discussion (Misc queries) | |||
Runtime 1004 error -- insert method of range class failed. | Excel Discussion (Misc queries) | |||
AutoFilter method of Range Class Failed | Excel Programming | |||
AutoFit method of Range class failed | Excel Programming |