Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to be able to insert a picture in a variety of cells (each cell
is a range object in the object arrayofRanges). Can someone help me with where I am going wrong? I have a feeling I dont get the whole set for pictures right. Sub TestPictureInsert() 'declarations Dim picQCAnormal As Picture Set picQCAnormal = _ Worksheet(2).Pictures.Insert("C:\oneCell_normal.bm p") Dim pic As Picture 'Put a picture the size of each range in each range _ (each range is only one cell) For each rnge in arrayofRanges Set pic = picQCAnormal With pic .Top = rnge.Top .Left = rnge.Width .Width = rnge.Width .Height = rnge.Height End With Next rnge End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inserting a Picture using Cell as picture name. | Links and Linking in Excel | |||
Problem inserting a picture and getting it to go behind the data | Excel Discussion (Misc queries) | |||
Problem inserting a picture in Excel that ONLY shows when clicked | Excel Discussion (Misc queries) | |||
Very strange problem when inserting a picture in a 3D Chart | Charts and Charting in Excel | |||
get a picture width and height without inserting the picture | Excel Programming |