Monthly Archives: March 2013

Home/2013/March

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


show developer tab excel 2010excel 2007 shortcut keysexcel vba saveas fileformatadd developer tab to the ribbon in word 2010case statement vba accessunhide column excelhyperlink macroddl dml tclsql query interview questions and answers for freshers pdfdelete sheet vbalookup functions in excel 2010example for vlookupdml commands in sql with syntax and examplesvlookup excel column index numbertableau tutorial for beginners pdfmicrosoft office project plan templateexcel hyperlink to pdfexcel vba resizehow do i insert a row in excelvba excel for beginnerstutorial for macros in excelvba dynamic arraymicros and macros in excelaccess vba if statementexcel merge columnspivot tables for beginnershow do i unhide columns in excelexcel ctrl enterexcel vba boldexcel call function from cellvb 6.0 interview questionslearn formulas in excelcountif in excel 2007extract hyperlink from excelhow to create activex controlcolumn index number in excelexcel remove blank columnsvba programming guidehow to add developer tab to the ribbonaccess vba open excel workbookms access vba run sqlvba activecell.rowsimple pie chart worksheetexcel vba guidedays360 excel formulavba stringsadvanced excel 2007 formulas with examplesproject roadmap exceluserform excelsas programmer interview questions and answersexcel duplicate linesaccess 2013 msgboxexcel counting functionsexcel vba msgbox vbyesnoexcel hide a worksheetvba activexvb scripting interview questions and answersfind duplicates excel 2003no of rows and columns in excel 2007vba row hideexcel vba select rowunshare excel spreadsheetexcel vba read xml fileadodb parameterized queryexcel averageifwhere to find developer tab in excel 2007project plan timeline excel templatevba development toolsexcel formulas shortcut keys 2007excel formulas for data analysisconversion of xml file to excel