vishwamitra

About Vishwamitra Mishra

My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor’s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.
Thanks for visiting my blog.

Excel Tip: How to refer characters using ASCII Value

Hello friends, In this article, I am going to explain you, how can you use special characters in Excel VBA and formulas without breaking the syntax. For Example: You can not use double quote or any other Special Characters, which are generally a part of Formula Syntax,  directly in a cell while using formula because using them, will spoil the [...]

How to find Visible Range in Excel window on a Screen

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 confused with the visible or [...]

Wish you Merry Christmas & happy Holidays

Happy Holidays To wish you and your family a very Happy Holidays and Merry Christmas, I have prepared an Animated Christmas tree lights with snow man, snow flakes etc. in excel sheet with the help of simple bubble graphs, formulas and a simple VBA code to Start and Stop the animation. Wish you a very Happy Holidays and [...]

Excel VBA Tips: How to comment or uncomment a Block of Code in VBA

Comment the codes Dear Friends, Providing proper short descriptions for each of your functions or statements etc. makes your VBA code - easy to read, easy to understand by anyone who refers your code. Now the question is, how can you write description in English language in between your VBA code? VBA compiler will start giving compile error. [...]

Excel VBA Basics : All about Debugging Excel VBA code

Dear All, Debugging VBA Code In Tutorial section for Beginners, I have written many basic articles like WHAT IS EXCEL MACRO, HOW TO WRITE IT, WHERE TO WRITE IT etc. As you know Errors are common while writing your code in VBA or in any other programming language for that matter. This is not a problem. As long [...]

Complete VBA tutorial to interact with Power point Presentations – Part – 2 of 2

This is a continuation of my previous article about Interaction with Power point Slides using Excel Macro. In my previous article we learn how to create a New Power Point Presentation using Excel Macro (by creating Power Point Object). Bit of a Story about this Article: This article I planned to write due an incident took place at my work. [...]

Register Yourself for FREE Session on “Basics of Excel VBA”

Dear Readers,   LearnExcelMacro.com is going to conduct a FREE online session on "Basics of Excel VBA". This session is going to be conducted on Google-Hangout hence to receive an invite for this FREE session you need to register yourself by submitting the below form. If below form is not visible properly, kindly click on below link to register yourself [...]

Wishing you and your Family a Very Happy Diwali

Wishing you a very Happy Diwali to you and your family. May this Diwali brings health, wealth and prosperity in your life. May this festival of Lights brings light in each one of your life For my readers who does not know about this festival: This an Indian Festival called as "Festival of Lights". It is also known as "DEEPAVALI". [...]

By |Categories: Personal|Tags: , |0 Comments

Complete VBA tutorial to interact with Power point Presentations – Part – 1

D ear Friends, First of all, I apologize for not responding to many of your questions around dealing with PowerPoint presentations through Excel Macro. Many of you have sent me so many questions around this topic. Questions, which were, mostly, asked were like - Sample List of Questions...   VBA code to create a presentation slide based on a [...]

Excel VBA Tips – Two excel VBA Tricks to help in day-to-day Coding

Dear Readers,   In this article I am going to share with you - Two little VBA code which will help you in your day-to-day coding life. 1. How to disable Copying Objects with cells through VBA When you are trying to move or copy a Sheet or set of Sheets in to another workbook then by default it copies [...]

Page 5 of 21« First...34567...1020...Last »