I want to know how to write the macro to insert new rows in the shared excel file, in shared mode I can insert rows manually, however if I write macro to do this, it gives me the error message "Run-time error 1004. Insert method of Range class failed", if I disable the shared mode, the macro runs fine, how to solve this issue, any idea?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to insert rows in shared excel file?
- Thread starter alan123
- Start date
Similar threads
- Locked
- Question
- Locked
- Solved
- Locked
- Question
- Locked
- Question