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.

How to refer Values from a Named Range – Excel VBA

Dear Readers, I am writing this new article about How can you read values stored in a Name range in Excel Sheet in Excel Macro . For the readers who are unaware or need more information about the Name Range, I would suggest you to first go through the below mentioned article before jumping up to this article. Click on [...]

Excel Tip : How to Make an Excel Cell secured for Password

One of my friend wanted me to write an article on How can a person achieve making an Excel Cell behave like a password text box which is masked and secured. I have tried to achieve that up to some extent but not 100%. Go through with this article and provide your feedback or suggestion regarding this topic !!. You [...]

Excel Macro : Excel VBA code to Protect OR UnProtect Sheet

Hello Friends, This is a small VBA code to help you in dealing with Protecting and UnProtecting the WorkSheet using Excel Macro. Assuming the fact here that you know How to Protect or UnProtect a Sheet using Excel In-Built function . For those who does not know protect or unprotect the sheet using Excel inbuilt function, I will give a [...]

Excel Macro : Excel VBA code to Print the Sheet

Hello Friends, Hope you are doing well !! Thought of sharing a small VBA code to help you writing a code to print the Workbook, Worksheet, Cell Range, Chart etc. .PrintOut () Method is used to print any Excel Object. Syntax of .PrintOut Method YourObj.PrintOut(From, To, Copies, Preview, ActivePrinter, PrintToFile, Collate, PrToFileName, IgnorePrintAreas) Where: YourObj (Required): It is a variable [...]

VBA String Functions – INSTR() Function

Instr() Function This is a VBA function and not a Worksheet function (Excel formula). This function returns the Position of First Occurrence of a SubString in a String. SubString could be a letter, Word or Sentence etc. It means this function always returns an Integer value. As mentioned in the definition of this function, it always returns the position number [...]

Spreading data across Columns in Excel Without VBA Code

In my previous article as you learnt how to split data using VBA SPLIT() function. In this Article I am going to explain you how to separate the data across columns of a cell without excel VBA. Microsoft Excel has a built-in function called Text-to-Columns under Data ribbon (refer the Pic 1). Using this option user can split the data [...]

Read and Write Document Properties of an excel Document – VBA

In this Article we will learn how to get document property of an excel workbook using Excel VBA. Before I jump in to the VBA code let's have a look Where to see document properties in Excel Document? How to see document property of an Excel document Follow the below steps to see the properties for the document: Step 1. [...]

Excel VBA – What is SPLIT Function?

Split is the hardest shot to hit in Bowling. But unlike bowling SPLIT is very simple function to use in excel VBA. Splitting data or string in VBA, sometimes becomes necessary to organize it and to put it in more readable format. SPLIT-function Here in this article, you will learn about splitting the data/string which is joined [...]

Excel OFFSET Function – Excel Tutorial

Dear Friends, What is OFFSET () Function? OFFSET() is a built-in function in excel which returns a range reference which is offset a number of Rows and Columns from a specific Cell or range. Most importantly this is a function which returns Range Address and not the Value. Did you get it what it is used for? No? Don't worry [...]

Excel Trick – Sheet Protection – Protect it and Stay Free

Dear Readers, I am back with another Excel Trick which is very much common while managing your sheet with certain security (protection). To protect the whole Worksheet can be easily done by using the Protect Sheet option available in Microsoft Excel. But in this article I am going to explain you, How to protect your whole sheet except a cell [...]