Automatic picture formatting available ?
 

Hello everybody,

I did a search on this and couldn't find anything so here goes...

I capture and paste alot of images into excel from the clipboard.
Once pasted i have to select "Format Picture" function in order
to get the size so that the pasted picture actually fits the excel
cells. Is there anyway to make the pasted pictures automatically
size themselfes to the cells ?

Or perhaps set a default setting in the "Size" tab in "Format Picture"
so that pasted pictures always gets the same size without me being
forced to write them in explicitly everytime ?

Thanks / Fal

You could use this macro:

Public Sub FitPictureToCell()
Dim rCell As Range
If TypeName(Selection) = "Picture" Then
With Selection
Set rCell = .TopLeftCell
.Top = rCell.Top
.Left = rCell.Left
.Width = rCell.Width
.Height = rCell.Height
.Placement = xlMoveAndSize
End With
Else
MsgBox "Please select a picture."
End If
End Sub

If you're not familiar with macro, see David McRitchie's "Getting
Started with Macros":

http://www.mvps.org/dmcritchie/excel/getstarted.htm


In article ,
"Falaffel" wrote:

I capture and paste alot of images into excel from the clipboard.
Once pasted i have to select "Format Picture" function in order
to get the size so that the pasted picture actually fits the excel
cells. Is there anyway to make the pasted pictures automatically
size themselfes to the cells ?

Or perhaps set a default setting in the "Size" tab in "Format Picture"
so that pasted pictures always gets the same size without me being
forced to write them in explicitly everytime ?