Macro for variable picture
- From: _Nate <n8dissmeyer@xxxxxxxxx>
- Date: Wed, 12 Dec 2007 08:25:21 -0800 (PST)
....
Sheets("Actions").Select
Range("B16").Select
sImageToLoad = Sheets("Macros").Range("A2")
Active***.Pictures.Insert (sImageToLoad)
Active***.Shapes ("Picture 37")
Selection.ShapeRange.ScaleWidth 1.34, msoFalse,
msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 1.34, msoFalse,
msoScaleFromTopLeft
....
I need help with the proper format to make "Picture 37" a variable in
the function. Each time this step is run in large macro, the picture
number changes.
Many thanks in advance.
_Nate
.
- Follow-Ups:
- RE: Macro for variable picture
- From: Joel
- RE: Macro for variable picture
- Prev by Date: Re: Date changes to ### when next cell is blank - why?
- Next by Date: Re: Losing fields after CSV conversion
- Previous by thread: Re: Calculating the difference between 2 dates and times
- Next by thread: RE: Macro for variable picture
- Index(es):