I'm using Excel97.
How can I insert a picture, for example "C:\pictures\mypic.jpg" into a
block of cells, for example "A2:K15" by vba-code ? Ist it possible to
format a inserted picture ?
thanks for your help!
Henning
Here's the basics of inserting a picture with top left at A2.
Sub Macro2()
Range("A2:K15").Select
ActiveSheet.Pictures.Insert("D:\jpgs From the Net\Finance\Euronotes
Pastiche (BBC).jpg").Select
End Sub
As to formatting, I suggest you use the macro recorder and study the
generated code for what you want to do.
hth
"Henning Winkler" <Henning...@t-online.de> wrote in message
news:3BC5A24B...@t-online.de...
thanks! Code works well.
Henning
Norman Harker schrieb: