{"id":4516,"date":"2015-12-26T17:50:17","date_gmt":"2015-12-26T17:50:17","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=4516"},"modified":"2022-08-12T11:40:58","modified_gmt":"2022-08-12T11:40:58","slug":"visible-range-in-excel-active-window","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/","title":{"rendered":"How to find Visible Range in Excel window on a Screen"},"content":{"rendered":"<p>Dear Friends,<\/p>\n<p>Its been a while I posted any post here. I am back with so many interesting stuff for you in Excel VBA. Here is a very small but useful excel vba tip for you.<\/p>\n<p>This is about knowing the range which are currently visible to the user on his\/her screen. Do not get confused with the visible or hidden cell here. This is not about that. This is more about how many rows and columns are visible of your excel window on different size of screens.<\/p>\n<p>It is a very simple command in VBA which gives you the visible range on your screen.<\/p>\n<pre><code class=\"language-vbnet\">\n\nActiveWindow.visibleRange\n<\/code><\/pre>\n<p>Above statement returns an Object of Range Type. <\/p>\n<p>From the above statement it is clear that <strong>VisibleRange<\/strong> is a method of ActiveWindow of an Excel. It is not related to a particular workbook but it works on ActiveWindow.<\/p>\n<h3>What is the use of this Method? <\/h3>\n<p>This is not a very common method to be used. But this is useful if you are trying to display some data in different format based on the visible range of your excel sheet for a different users having different size of monitors.<\/p>\n<h2>To Make a particular Cell or Range in Center of the Screen<\/h2>\n<p>To do so, I will have to identify the center of the screen because every screen might have different size.<\/p>\n<p>Here the tricky part is identifying the Center of the screen Making a particular cell or cell range because center of the screen may vary for different size of screens. In this case, this method will help you making a cell range in the center of the screen.<\/p>\n<p>To Scroll to a particular cell in Excel, we will use Application.GoTo method.<\/p>\n<h2>What is Application.GoTo Method and how it is used here? <\/h2>\n<p><strong>Application.GoTo<\/strong> Method in Excel VBA takes input as a Range where you want to scroll and make that cell visible on the screen. This method always scroll the screen to make the cell at Top-Left corner cell on the screen. Here in this article I am not covering much about <strong>Application.GoTo<\/strong> method. Refer the below image:<br \/>\n<div id=\"attachment_4518\" style=\"width: 395px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-4518\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Application.GoTo_.png\" alt=\"GoTo Method\" width=\"385\" height=\"421\" class=\"size-full wp-image-4518\" \/><p id=\"caption-attachment-4518\" class=\"wp-caption-text\">Application.GoTo Method<\/p><\/div><\/p>\n<p><strong>For Example<\/strong>, To make Cell <bZ16<\/strong> to be visible in Center of the screen, if I use <strong>Application.GoTo Range(&#8220;Z16&#8221;), TRUE<\/strong> method then Z16 cell will be visible at the top left corner of the screen which is not my expectation. My expectation is to display Z16 cell always in center of my screen.<br \/>\n<&nbsp;\nIf I know how many rows and how many columns are visible on the screen, then by using the ActiveWindow.VisibleRange method, I can always find such address by using below formula which if kept at the top left corner then <strong>Z16<\/strong> will remain in center.<\/p>\n<p>&nbsp;<\/p>\n<h3>Formula to find Top Left Row<\/h3>\n<p> = First Row Number of MyCell + (total row number of myCell Range)\/2 &#8211; half of total number of rows visible on the screen<\/p>\n<h3>Formula to find Top Left Left Column<\/h3>\n<p> = Column Number of MyCell  + (total Column number of myCell Range)\/2 &#8211; half of total number of columns visible on the screen<\/p>\n<h2>Exception Scenarios<\/h2>\n<p>Consider a scenario where Row Number of My Cell is less than half of total number of rows visible on the screen. In such case I would like 1 as a Top left row number. Similarly for columns as well.<\/p>\n<h2>Solution:<\/p>\n<h2>\nTo handle the above scenario you can take a max value between 1 and the difference which is being calculated like below<\/p>\n<h3>Formula to find Top Left Row<\/h3>\n<p> = MAX(1, First Row Number of MyCell + (total row number of myCell Range)\/2 &#8211; half of total number of rows visible on the screen)<\/p>\n<h3>Formula to find Top Left Left Column<\/h3>\n<p> = MAX(1, Column Number of MyCell  + (total Column number of myCell Range)\/2 &#8211; half of total number of columns visible on the screen)<\/p>\n<p>Using <strong>ActiveWindow.VisibleRange<\/h2>\n<p> method we can get the row and column count dynamically for each type of screens.<\/p>\n<pre><code class=\"language-vbnet\">\nSub MakeItInCenter(myCell As Range)\nDim VisibleRows\nDim VisibleColumns\nDim GoToRow\nDim GoToCol\n\nVisibleRows = ActiveWindow.visibleRange.Rows.Count\nVisibleColumns = ActiveWindow.visibleRange.Columns.Count\n\n' To make the myCell as center, calculate the reference\n' Cell address for Application.GoTo Method\n' Plesae read the explanation provided on the\n' LearnExcelMacro.com article.\nGoToRow = Application.WorksheetFunction.Max _\n(1, myCell.Row + (myCell.Rows.Count \/ 2) - (VisibleRows \/ 2))\nGoToCol = Application.WorksheetFunction.Max _\n(1, myCell.Column + (myCell.Columns.Count \/ 2) - (VisibleColumns \/ 2))\n' Now use GoTo Method to scroll to the screen to make myCell visible in Center\nApplication.Goto Parent.Cells(GoToRow, GoToCol), True\nEnd Sub\n<\/code><\/pre>\n<h2>How to use above Procedure in your code<\/h2>\n<p><strong>Step 1.<\/strong> Copy the above Procedure<\/strong><br \/>\n<strong>Step 2. <\/strong> Go to your VBA Screen and Add a <a href=\"https:\/\/vmlogger.com\/excel\/2014\/05\/how-to-create-custom-functions-in-excel\/\" target=\"_blank\" rel=\"noopener\">Module <\/a><br \/>\n<strong>Step 3.<\/strong>Paste this code<br \/>\n<strong>Step 4.<\/strong> Now call this function from anywhere in your program by using below statement:<\/p>\n<pre><code class=\"language-vbnet\">\n\nCall MakeItInCenter (Range(\"Z16\")\n\n<\/code><\/pre>\n<p><\/p>\n<p>Thank you so much friends for reading&#8230; Hope this helps you in your day-to-day programming in VBA. <\/p>\n<p>Soon I will be sharing few tools which I developed in this idle period.. till then have a nice time.. \ud83d\ude42 Keep reading<\/p>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>Dear Friends, Its been a while I posted any post here. I am back with so many interesting stuff for you in Excel VBA. Here is a very small but useful excel vba tip for you. This is about knowing the range which are currently visible to the user on his\/her screen. Do not get [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":0,"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":[1246,1679,1676],"tags":[],"class_list":["post-4516","post","type-post","status-publish","format-standard","hentry","category-macro","category-excel-macro-beginner","category-excel-tips"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.5 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to find Visible Range in Excel window on a Screen - Let&#039;s excel in Excel<\/title>\n<meta name=\"description\" content=\"Learn everything about Application.GoTo method as well as Activewindow.VisibleRange method. Centering a cell on screen. Make my cell visible in the center of every screen.\" \/>\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\/2015\/12\/visible-range-in-excel-active-window\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to find Visible Range in Excel window on a Screen\" \/>\n<meta property=\"og:description\" content=\"Learn everything about Application.GoTo method as well as Activewindow.VisibleRange method. Centering a cell on screen. Make my cell visible in the center of every screen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;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=\"2015-12-26T17:50:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-12T11:40:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Application.GoTo_.png\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"How to find Visible Range in Excel window on a Screen\",\"datePublished\":\"2015-12-26T17:50:17+00:00\",\"dateModified\":\"2022-08-12T11:40:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/\"},\"wordCount\":383,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Application.GoTo_.png\",\"articleSection\":[\"Excel Macro\",\"Excel Macro Beginner\",\"Excel Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/\",\"name\":\"How to find Visible Range in Excel window on a Screen - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Application.GoTo_.png\",\"datePublished\":\"2015-12-26T17:50:17+00:00\",\"dateModified\":\"2022-08-12T11:40:58+00:00\",\"description\":\"Learn everything about Application.GoTo method as well as Activewindow.VisibleRange method. Centering a cell on screen. Make my cell visible in the center of every screen.\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Application.GoTo_.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Application.GoTo_.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to find Visible Range in Excel window on a Screen\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;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 &amp; 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 find Visible Range in Excel window on a Screen - Let&#039;s excel in Excel","description":"Learn everything about Application.GoTo method as well as Activewindow.VisibleRange method. Centering a cell on screen. Make my cell visible in the center of every screen.","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\/2015\/12\/visible-range-in-excel-active-window\/","og_locale":"en_US","og_type":"article","og_title":"How to find Visible Range in Excel window on a Screen","og_description":"Learn everything about Application.GoTo method as well as Activewindow.VisibleRange method. Centering a cell on screen. Make my cell visible in the center of every screen.","og_url":"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2015-12-26T17:50:17+00:00","article_modified_time":"2022-08-12T11:40:58+00:00","og_image":[{"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Application.GoTo_.png"}],"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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"How to find Visible Range in Excel window on a Screen","datePublished":"2015-12-26T17:50:17+00:00","dateModified":"2022-08-12T11:40:58+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/"},"wordCount":383,"commentCount":2,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Application.GoTo_.png","articleSection":["Excel Macro","Excel Macro Beginner","Excel Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/","url":"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/","name":"How to find Visible Range in Excel window on a Screen - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Application.GoTo_.png","datePublished":"2015-12-26T17:50:17+00:00","dateModified":"2022-08-12T11:40:58+00:00","description":"Learn everything about Application.GoTo method as well as Activewindow.VisibleRange method. Centering a cell on screen. Make my cell visible in the center of every screen.","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Application.GoTo_.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Application.GoTo_.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"How to find Visible Range in Excel window on a Screen"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;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 &amp; 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\/4516"}],"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=4516"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4516\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=4516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=4516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=4516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}