![]() |
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