Object doesn't support this property or method (Error 438)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
| 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
|
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maco code doesn't work. Why? 2
What does this error mean. Help. 2
How To Find If The ActiveCell Is Protected 7
Runtime error 8
Object doesn't support this property or method (Error 438) 2
Runtime error 5
RunTimeError-438 XL2007-->XL2003 Compatibility Issues 4
Run time error '438'. Object doesn't support this property or meth 3

Back
Top