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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Editing MY excel files in Access with VBA

Status
Not open for further replies.

esengul

Instructor
Dec 9, 2004
59
US
With oExcel
.Sheets("FirstEntry").Range("A1:E2").Select
.Selection.Cut
.Sheets("FirstEntry").Range("A10").Select
.ActiveSheet.Paste
.Sheets("FirstEntry").Range("A1").Select
.ActiveSheet.Pictures.Insert("C:\mypicture.jpg").Select
End With

i have this code to move cells to down and insert a picture. i get an error message saying "runtime error '9' _ Subscript out of range"
Please tell me what i am doing wrong?
Thanks in advance
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top