{"id":12179,"date":"2013-06-30T13:45:36","date_gmt":"2013-06-30T13:45:36","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=3065"},"modified":"2017-09-04T13:45:16","modified_gmt":"2017-09-04T13:45:16","slug":"insert-a-picture-in-excel-using-vba","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/","title":{"rendered":"How to insert a picture in excel using VBA"},"content":{"rendered":"

Dear Friends,
\nIn this article, I am going to teach you a simple VBA code, which help you in inserting a picture in Excel Sheet. I will also discuss about difference between Inserting a picture in Excel and Embedding a picture in Excel Sheet using Excel VBA.
\nIt is based on request from one of LEM reader who wants to know, <\/i>How to insert a picture in excel sheet using VBA code<\/i><\/strong> It is a very simple one liner code to insert a picture in Excel using vba code.
\n

\"Insert

Insert Picture Using VBA Code<\/p><\/div><\/p>\n

Basically, there are two methods to insert a picture in Excel Sheet
\nMethod 1.<\/strong> ActiveSheet.Pictures.Insert
\nMethod 2.<\/strong> ActiveSheet.Shapes.AddPicture<\/p>\n

VBA Code for Inserting Picture in Excel Sheet [Method 1]<\/h1>\n

Using .Pictures.Insert()<\/strong> method, you can insert a picture in Active sheet. Let see the Syntax of this method:<\/p>\n

Syntax of .Pictures.Insert<\/em> Method<\/h2>\n

[highlight color=”yellow”]ActiveSheet.Pictures.Insert(‘Picture URL’)[\/highlight]<\/p>\n

This function requires only one parameter – Full path of the picture to be inserted in Excel Sheet. This is a mandatory <\/strong>parameter here. <\/p>\n

For Example:<\/h1>\n

ActiveSheet.Pictures.Insert(“C:\\….\\myPic.jpg”)<\/p>\n

Above statement will simply insert myPic.jpg<\/em><\/strong> picture in Active sheet in its original Size.
\nIf you want to resize and locate the picture according to you, then use the following statement to resize the image and place it where ever you want in the excel sheet.<\/p>\n

1. VBA Code to re-size (height and width) the inserted picture<\/h2>\n

Below code will set the height and width of the selected picture in worksheet which is inserted using VBA code:<\/p>\n

\r\n    With ActiveSheet.Pictures.Insert("Picture full path")\r\n        .Left = 110\r\n        .Top = 220\r\n        .Width = 123\r\n        .Height = 134\r\n    End With\r\n<\/code><\/pre>\n
Explanation and issues with above Code<\/h2>\n
Left and Top will be set without any issue.
\nLater, Width of the image will be set to 123 as specified – Height of the image will be automatically set to a respective height to the width – because AspectRatio<\/em><\/strong> of the image is by default set to True<\/strong>
\nSimilarly when control goes to the next statement then it will reset the height to 134 and since, aspect ratio is false, width will be adjusted to new respective value.<\/p>\n
Challenge here is that you can NOT set AspectRatio flag <\/strong>of the picture while inserting it. (by above statement)<\/p>\n
Therefore, be careful while resizing the picture while inserting it by using the above code<\/p>\n
So what is the solution?<\/h2>\n
Here is the solution…
\n1. first add the picture in its own size.
\n2. Store the name of this image (uniquely generated one) in a variable. So that you can refer this picture uniquely later on
\n3. Using this variable, select that Shape and set the aspect ratio to false<\/strong>
\n4. Then set the height and width of the picture.<\/p>\n
Here is the code now…<\/strong><\/p>\n
\r\n    Dim nameOfPicture as String\r\n    With ActiveSheet.Pictures.Insert("Picture file full path")\r\n        .Left = ActiveSheet.Range("photograph").Left + 2\r\n        .Top = ActiveSheet.Range("photograph").Top + 2\r\n        nameOfPicture= .Name\r\n    End With\r\n    ActiveSheet.Pictures(profile).Select\r\n    With Selection.ShapeRange\r\n        .LockAspectRatio = msoFalse\r\n        .Width = 123\r\n        .Height = 134\r\n    End With\r\n<\/code><\/pre>\n
2. VBA Code to set the location of the inserted Picture<\/h2>\n
Here you can either set fixed Left and Top value where you want to place your picture. In this case no matter what is the height and width of the cell in the worksheet, your picture will be always placed at a specific location. But suppose if you want – your picture should always be placed at a specific row and column then you can set the left and top values as follows:<\/p>\n
\r\n    With ActiveSheet.Pictures.Insert(&lt;path of your picture in local drive&gt;)\r\n        .Left = ActiveSheet.Range("A1").Left \r\n        .Top = ActiveSheet.Range("A1").Top \r\n        .Placement = 1\r\n    End With\r\n<\/code><\/pre>\n
Now your selected picture will always be placed where Column A1 starts from left and Row 1 starts from top. It means even if you change height or width of the Range A1, your picture is always going to be in Range A1 only.<\/em><\/p>\n
\n
Warning!<\/strong>
\nThis method, simply links the image in to your Excel Sheet. It means, after inserting a picture, using this method, if you send it to another computer, picture will not be displayed and an Error message be displayed.<\/p>\n
Therefore, this method is good only when you are going to use this excel sheet always in your own computer.<\/p><\/div>\n
VBA Code for Embedding Picture in Excel Sheet [Method 2]<\/h1>\n
Using .Shapes.AddPicture()<\/strong> method, you can insert a picture in Active sheet. This method overcome the challenges of above method. This allows user to Embed the picture with the Excel Workbook itself. It means, even if you share the workbook to other computer… this picture will go with the document and you will be able to see it in other computer as well.<\/p>\n
Syntax of .Shapes.AddPicture<\/em> Method<\/h2>\n
[highlight color=”yellow”].Shapes.AddPicture( Filename , LinkToFile , SaveWithDocument , Left , Top , Width , Height )[\/highlight]<\/p>\n
Where:<\/h2>\n
Filename : (Mandatory)<\/strong> As the names suggests, this is the complete file path of the picture you want to embed to your Excel Sheet
\nLinkToFile : (Mandatory)<\/strong> MsoTriState- True or False – To set whether you want to create a link to the file?
\nSaveWithDocument : (Mandatory)<\/strong> MsoTriState – True or False – This is the flag which needs to be set to TRUE to embed the picture with Excel Sheet.
\nLeft : (Mandatory)<\/strong>The position of the upper-left corner of the picture with respect to the upper-left corner of the document.
\nTop : (Mandatory)<\/strong> The position (in points) of the upper-left corner of the picture with respect to the top of the document.
\nWidth : (Mandatory)<\/strong> The width of the picture you want to set. To keep the picture in its original width provide -1<\/em>
\nHeight : (Mandatory)<\/strong> The Height of the picture you want to set. To keep the picture in its original Height provide -1<\/em><\/p>\n
Example:<\/h1>\n
Following VBA code will Embed this picture with the Excel file and it will display in any computer you sent it. <\/p>\n
\r\nActiveSheet.Shapes.AddPicture _\r\nFilename:="full path of your file with extension", _\r\nlinktofile:=msoFalse, savewithdocument:=msoCTrue, _\r\nLeft:=50, Top:=50, Width:=250, Height:=250\r\n<\/code><\/pre>\n
\n
Info ! <\/strong>
\nTherefore .Shapes.AddPicture Method can insert a picture with and without links just simply by passing some flags. <\/div>\n
For your practice I have created an Excel workbook which you can download and play around.
\n
\n
\"VBA
VBA Code Insert Picture  – Sample Workbook<\/p><\/div>
\n
\n <\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"
Dear Friends, In this article, I am going to teach you a simple VBA code, which help you in inserting a picture in Excel Sheet. I will also discuss about difference between Inserting a picture in Excel and Embedding a picture in Excel Sheet using Excel VBA. It is based on request from one of […]<\/p>\n","protected":false},"author":45,"featured_media":14265,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1674,1682],"tags":[],"class_list":["post-12179","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-macro-basics","category-popular-articles"],"yoast_head":"\nHow to insert a picture in excel using VBA - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"Insert picture in Excel using Excel VBA. Excel VBA to Embed picture in excel. Solution: Inserted Picture not displayed in Another computer. Resize embedded picture\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to insert a picture in excel using VBA\" \/>\n<meta property=\"og:description\" content=\"Insert picture in Excel using Excel VBA. Excel VBA to Embed picture in excel. Solution: Inserted Picture not displayed in Another computer. Resize embedded picture\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2013-06-30T13:45:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-09-04T13:45:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/Insert-Picture-using-VBA-Code-2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"538\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"How to insert a picture in excel using VBA\",\"datePublished\":\"2013-06-30T13:45:36+00:00\",\"dateModified\":\"2017-09-04T13:45:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/\"},\"wordCount\":1023,\"commentCount\":36,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/Insert-Picture-using-VBA-Code-2.jpg\",\"articleSection\":[\"Excel Macro Basics\",\"Popular Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/\",\"name\":\"How to insert a picture in excel using VBA - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/Insert-Picture-using-VBA-Code-2.jpg\",\"datePublished\":\"2013-06-30T13:45:36+00:00\",\"dateModified\":\"2017-09-04T13:45:16+00:00\",\"description\":\"Insert picture in Excel using Excel VBA. Excel VBA to Embed picture in excel. Solution: Inserted Picture not displayed in Another computer. Resize embedded picture\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/Insert-Picture-using-VBA-Code-2.jpg\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/Insert-Picture-using-VBA-Code-2.jpg\",\"width\":800,\"height\":538,\"caption\":\"Insert-Picture-using-VBA-Code\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro Basics\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-macro-basics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to insert a picture in excel using VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to insert a picture in excel using VBA - Let's excel in Excel","description":"Insert picture in Excel using Excel VBA. Excel VBA to Embed picture in excel. Solution: Inserted Picture not displayed in Another computer. Resize embedded picture","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/","og_locale":"en_US","og_type":"article","og_title":"How to insert a picture in excel using VBA","og_description":"Insert picture in Excel using Excel VBA. Excel VBA to Embed picture in excel. Solution: Inserted Picture not displayed in Another computer. Resize embedded picture","og_url":"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2013-06-30T13:45:36+00:00","article_modified_time":"2017-09-04T13:45:16+00:00","og_image":[{"width":800,"height":538,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/Insert-Picture-using-VBA-Code-2.jpg","type":"image\/jpeg"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"How to insert a picture in excel using VBA","datePublished":"2013-06-30T13:45:36+00:00","dateModified":"2017-09-04T13:45:16+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/"},"wordCount":1023,"commentCount":36,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/Insert-Picture-using-VBA-Code-2.jpg","articleSection":["Excel Macro Basics","Popular Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/","url":"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/","name":"How to insert a picture in excel using VBA - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/Insert-Picture-using-VBA-Code-2.jpg","datePublished":"2013-06-30T13:45:36+00:00","dateModified":"2017-09-04T13:45:16+00:00","description":"Insert picture in Excel using Excel VBA. Excel VBA to Embed picture in excel. Solution: Inserted Picture not displayed in Another computer. Resize embedded picture","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/Insert-Picture-using-VBA-Code-2.jpg","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/09\/Insert-Picture-using-VBA-Code-2.jpg","width":800,"height":538,"caption":"Insert-Picture-using-VBA-Code"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2013\/06\/insert-a-picture-in-excel-using-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro Basics","item":"https:\/\/vmlogger.com\/excel\/excel-macro-basics\/"},{"@type":"ListItem","position":3,"name":"How to insert a picture in excel using VBA"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12179"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12179"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12179\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/14265"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}