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

ms access remove duplicatesxluppassword protecting excel 2010how to send email using vbarecording macros in exceladvanced sql interview questions and answers pdfrun sql query in excelcopy data from multiple worksheets into onefonts with underlinevba createtextfilevba excel save workbookadjust row height in excelexcel vba tipsexcel calculate sheet shortcutvba excel commentexcel macro dimexcel macro for loopinserting a column in excelexcel vba range sortworksheet or workbookunprotect worksheet vbalearn excel macrosql compare operatorsdim as worksheetworkbooks.worksheetsvba function syntaxhow to protect worksheet in excel 2007finding duplicates in excelvba rs openconcatenation excelhow to use sumif in excel 2007sumif formula excel 2010excel clear blank cellsfiledialog vbainstr syntaxexcell checkboxadding charts in excelsas interview questions with answers pdfadvanced excel 2007 formulas with examplesdelete blank cells in excelredim vbaconstruction estimate excel templateunique records in excelexcel vba forms advancedhighlight duplicates in excel 2003selection.pastespecialproject timeline template excelweekly report template ppthow to insert macro button in excel 2010dashboard examples in excelexcel vba application functiondeduplicate excelmicrosoft excel merging cellsinterview questions for freshers pdfexcel value lookuphow do i remove hyperlinks in exceladvanced filter in excel 2010shortcut to switch tabs in excelcombine multiple spreadsheets into onehow to remove macros from excelmessage in vbafind duplicates excelcombining sheets in excelexcel range macroaccess vba connection stringcreating a pie chart in excel 2010null value vbafind duplicate entry in excelpmo dashboard template excelvba sort rangehyperlink formula excelvba msgbox exampleexcel pivot tables explainedexcel vba delete entire rowhow to find out duplicates in excelvba worksheetfunctioncopy excel cell to another sheetsave xlsm as xlsx vbaprotecting an excel worksheet