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

vba macro in excelshade cells in excelenable macro excelremoving duplicates in excel 2010combine data from multiple worksheets into oneresource planning spreadsheet templatevba hello worldvba countifexcel example formulasmost useful formulas in excelshot keys of excelwindows excel shortcut keysselect cell vbafilesystemobject file existsexcel concatenate worksheetsconvert excel column width to inchesexcel vba close userformeliminating duplicate rows in excelvba timer examplevb scripting interview questions and answers pdfunprotect sheet vbaexcel formula cell colorexcel 2007 formulas with exampleshow do i sort alphabetically in excelinterview questions and answers in c programming language pdfcapacity planning spreadsheet excelmicrosoft excel tables tutorialgenpact technical interview questions and answersddl dcl dmlhow to draw pivot tablevba declare global variablevlookup with examplecounta in vbacheckbox vba excelmeeting minutes template excelcreate a checkbox in excelsoftware development estimation templateexcel vba bordersduplicate worksheet excelcombine worksheetshow to use averageifsadvanced excel vbavba clear celladodb connection providerappend string in excelremove duplicate rows in excelexcel check for duplicatesuseful excel formulasmerging cell in excelhow to add developer tab in powerpoint 2010change cell color in excel vbahow to unprotect an excel filedml meaningexcel 2007 tabsvba connection stringlookup and reference in excelvlookupfunctionunlock sheet excelauto refresh pivot table excel 2007do while loop vbaexcel vba best practicesprogramming excel vbahow to insert a comment in excelactivate a workbookvb carriage returnexcel concatenationcolor in excel formulahow to add data validation in excelc programming viva questions and answers pdfif statement in vba