Excel Macro Interview Questions and Answers

Well - If you are going to face the Excel Macro Interview then you have come to right place.
On this site, You will see important frequently asked questions in Excel Macro Interviews.

I have also given the answers to those questions with examples and codes. On left side of this page, you will find all advanced Interview Questions that are asked in Excel Macro Interviews.

Some sample interview questions are listed below :

• Macro code to add new workbook and save it
• Macro code to count blank values
• How to set the background color of cell using Excel Macro
• Macro to rename a excel worksheet
• different excel cell types in Macro
• How to Select Entire Row/Column in Excel VBA Macro
• Excel Macro to Send Email from Outlook with attachment
• Macro to add rows in Excel Sheet 
• Macro to remove blank rows from Excel sheet
• Macro to change the font color and size of Cell in Excel Macro
• Macro to calculate average of specified cell values in Macro

• Excel Macro to read data from text file
• Excel Macro to create text file
• How to create and use dictionary object in excel m...
• How to create and use array in excel macro
• How to create modules in Excel Macro
• Excel Macro to convert the data type of cell value...
• Excel Macro to split the cell value or string
• Excel Macro to extract the part of cell value or s...
• Excel Macro to remove the spaces from the cell val...
• Excel Macro to find the sub string
• Excel Macro to convert the string text to upper ca...
• Excel Macro to convert the text in lower case
• Excel macro to get the month name of given date
• Excel macro to get the day name of given date
• Excel Macro to get the date difference
• Excel Macro to get the stock data from yahoo finan...
• Excel Macro to process xml file
• Excel Macro to get stock finance data from Google ...
• Excel Macro to display a dialog box .
• Excel Macro to get the current system time
• Excel Macro to get the year from given date
• Excel Macro to get yesterday's date
• Excel Macro to add leading zero to cell value
• List of commonly used Excel functions

If you want to download the excel macro in pdf format, you can put your comment below.

All above questions are asked in Interviews of various IT companies like Infosys, IBM, Cognizant, TCS, HCL etc. I advise you to go through all the top 50-100 questions mentioned on this site before you face any Excel Macro Interview.