Hi,
This is the code that is giving the above error,
Set objList = Worksheets(1).ListObject(0).ListRows.Add
I got this code from the MS Help in excel. I am trying to dynamically add a
row at a specified location. Can anyone help with this.
Thanx
Hi,
This is the code that is giving the above error,
Set objList = Worksheets(1).ListObject(0).ListRows.Add
I got this code from the MS Help in excel. I am trying to dynamically add a
row at a specified location. Can anyone help with this.
Thanx
The object is ListObjects with an "s". Also the first one would have an
index of 1 so 0 I think is invalid
Worksheets(1).ListObjects(1).ListRows.Add
--
Jim
"Kiran" <[email protected]> wrote in message
news:[email protected]...
| Hi,
| This is the code that is giving the above error,
| Set objList = Worksheets(1).ListObject(0).ListRows.Add
| I got this code from the MS Help in excel. I am trying to dynamically add
a
| row at a specified location. Can anyone help with this.
| Thanx
|
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks