Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I found a snippit of code on an excel help website which is supposed to
insert a picture into a range of cells. However, when the code is run, I get a compile error saying the sub or function is not defined. Should the code below work? And if not, does anyone have any ideas on how to insert a picture into a specified range of cells? The only way I know of is the "addpicture" method where you have to specify in points where the image is insert, and how large to make the image. Using cell references for sizing and placement would be alot easier! I'm new to VBA, so simplified explanations would be appreciated! Here's the code I found: Sub TestInsertPictureInRange() InsertPictureInRange "C:\FolderName\PictureFileName.gif", _ Range("B5:D10") End Sub Thanks for you help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please post this thread a correct full method, method about | New Users to Excel | |||
Please post this thread a complete correct method, method about te | New Users to Excel | |||
GetObject method not work after Call Shell Method | Excel Programming | |||
Why QUIT method doesn't work after COPY method? | Excel Programming | |||
Excel OLE in VC++;AutoFormat Method | Excel Programming |