엑셀- 셀에 맞취 사진 넣기 매크로
Sub ins_Pic()
Dim myPic As Variant
myPic = Application.GetOpenFilename _
(filefilter:="Picture Files,*.jpg;*.bmp;*.tif;*.gif;*.jpeg")
If myPic = False Then
Exit Sub
End If
With ActiveSheet.Pictures.Insert(myPic).ShapeRange
.LockAspectRatio = msoFalse
.Height = Selection.Height
.Width = Selection.Width
.Left = Selection.Left
.Top = Selection.Top
End With
End Sub
'유틸 > 오피스' 카테고리의 다른 글
Microsoft Office 2013 With SP1 (7) | 2014.03.13 |
---|---|
[초보에요] Office_2013_VLSC_AIO_SP1_Korean (9) | 2014.03.09 |
MS Office 2010 & Hancom Office 2010 (14) | 2014.02.28 |
MS Office Freeware Edition (2) | 2013.04.11 |
Microsoft.OfficeProPlus.ProjectPro.VisioPro.2013.MUI.RETAiL2VOLUME-XDELTA3 (0) | 2013.02.19 |