Monthly Archives: March 2013


Inserting Columns in Excel Worksheet using VBA

Description: When we are automating any task we may required inserting columns between other columns or left/right side of a column using Excel VBA. For example, we may generate employee performance report based on their tenure in an organization. The first column would be 'Employee ID' and the last column would be 'Tenure (in months)'.

Inserting Rows in Excel Worksheet using VBA

VBA insert rows excel macro helps while automating and dealing with the records. For example, we may automate certain task based on the number of items in certain category. And the number of items may not be equal in all the situations it may vary time to time. We will see a practical example in

Running macro in Excel

We can execute a macro in many different ways, in this topic we will learn Running macro in Excel: From Macro Dialog and By assigning a short-cut key to the Macro Running Macro in Excel: Executing or From Macro Dialog Follow the below steps to assign a macro to a shortcut key: Step 1: Go

Hide UnHide Rows in Excel Worksheet using VBA

Description: We are required to Hide-UnHide the rows in some types of requirements. For examples we may have data for 3 different categories of items and we may want to show the respective items based on selection. In this case we can achieve by Hiding or Un-hiding the Rows. We will see this in the

AND Function in Excel

AND Function in Excel tests two or more conditions to see if they are all true.It returns TRUE if all conditions are TRUE, returns FALSE if any of the conditions is FALSE. AND function would be used in conjunction with another function such as IF function.

Accepting Values and Popup Messages in Excel VBA

Accepting Values and Popup Messages in Excel VBA - In this example we will see how to Accepting Values from user using InputBox and Show Popup Messages to user using MsgBox. Introduction We can show some Popup message to the user while executing the Macro using Message Box. Also, we can provide inputs to the

15 Must Known Excel Tips for Every Excel User

When we are working with some application, we use same method to finish some task. After sometimes we think for an alternative method to perform our task more faster and easy way. However, it will come with experience and take sometime to know the smarter way of doing the things. Now, its not required years of experince in Excel to work smarter! Spending sometime on reading this chapter will make you to execute the tasks smarterway and it will improve the prductiveit.

By |March 8th, 2013|Excel|4 Comments

Related pages

how to create dashboards in excelvlookup toolhow to delete cells in exceldelete duplicates in column excelactivecell selectexcel 2010 unhide rowsvb macrosaverageif formulalearn excel vlookupexcel macro insert rowarrays vba excelexcel practice tests for interviewsunhiding column atypes of errors in ms excelproject charter ppt presentationvba delete rowsexcel 2003 autosaveunprotect sheet excel 2007excel remove blank rowsprotecting a workbook in excelwhat is sumif functionhow to change width of a column in excelhow to locate duplicates in excelexcel collection vbashot keys of excelcheckbox in excel vbaexcel vba column countexcel hyperlink to folderprotect workbook excel 2007interview questions and answers for freshervba emptyworksheet functions vbaexcel worksheet vbahow to select entire column in excelexcel if cell containshow to unhide top rows in excelhow to create interactive charts in excelunlock a spreadsheetscheduling templates excelhow to add chart title in excel 2007excel macro functionsmacro remove blank rowsexcel vba end xldownusing worksheet functions in vbavba copy cellsdelete rows vbavba excel pivot tablesql in vba exceltechnical aptitude test questions and answersexcel insert rowsvba delete fileshow to merge cells in excel 2010ms excel highlight duplicatesexcel format vbaworksheetfunction.vlookup vbavb net excel set column widthdelete row in excel vbaexcel eliminate duplicate rowsvba range cells valuecost estimation software free downloadremoving duplicates in excel 2003vba columnwidthexcel 2010 hyperlinks change to local pathhow to run an excel macrocompound if statements excelcreate vba macroexcel isblank formulahow to find duplicates in excel 2013excel hyperlink to macroexcel macro scriptpaste special skip blanksactive row vbavba read text filelookup vba excelkpi dashboard in excel