General information
Category:
Coding, syntax & commands
Hi Yuri,
I was not explicit. I changed where I put the
".WorkSheets(1).Pictures.Insert"(CSCLogo)
line of code in the overal routine so the .gif would insert on the spread sheet where I wanted it.
WITH oExcel
&& Insert 3 rows:
.Cells(1,1).Value=[Insert row above this line]
.Range("A1").Select
.Selection.EntireRow.Insert
.Range("A2").Select
.Selection.EntireRow.Insert
.Range("A3").Select
.Selection.EntireRow.Insert
.Range("A4").Select
.Selection.EntireRow.Insert
*
.Range("B2").Select
.WorkSheets(1).Pictures.Insert(CSCLogo)
*
&& Insert 2 line title:
.Range("F1").Value = "INSUFFICIENT DATA REPORT"
ETC.
Thanks! Have a great weekend.
Paige
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only