PNRao

Home/PNRao

About PNRao

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

Hide Developer Tab in Excel Ribbon

Hide Developer Tab in Excel Ribbon using from the Excel options. It helps to prevent users from opening the Excel VBA editor window. Hide Developer Tab in Excel Ribbon: Right click on any main menu item in the Ribbon. Please find the below screen shot for the same. Click on Customize the Ribbon…, this will

By |October 8th, 2016|VBA|0 Comments

mongopono.ru Version 5.0.0

mongopono.ru Version 5.0.0 is releasing today. I have added new utilities to optimize the Excel workbooks and Navigate inside a worksheets and enhanced overall look and feel of windows. Visit mongopono.ru Excel Add-ins Page New Features Workbook Optimizer Now you can test your workbooks and create optimized workbook. Many of our friends have been requesting

VBA code to convert excel to xml

We can use VBA to convert and Save the Excel File as XML file. This example macro will help us to know how to convert Excel Worksheet into a XML file format. This can be used in Excel 2003,2007,2010,2013. vba code to convert excel to XML- Syntax Here is the example Excel VBA Syntax to

By |January 20th, 2015|VBA|0 Comments

VBA to call Worksheet function

We can use worksheet function in the VBA macros. We can call the worksheet functions using Application.WorksheetFunction. We can call any Worksheet function and use in our code. the below example will show you how to use the worksheet functions in VBA. VBA to call Worksheet function Here is the simple example to call the

By |January 20th, 2015|VBA|0 Comments

VBA code to call a function

The below example will help you to know how to call a function in Excel VBA Macros (it can be Excel VBA function, or user defined function). We generally create lot of function and we use the functions whenever and any time we want. The below example will help you to understand calling a simple

By |January 20th, 2015|VBA|1 Comment

VBA code to convert excel to csv

We can use VBA to convert and Save the Excel File as CSV file. This example macro will help us to know how to convert Excel Worksheet into a CSV Comma delimited text file. This can be used in Excel 2003,2007,2010,2013. vba code to convert excel to csv- Syntax Here is the example Excel VBA

By |January 20th, 2015|VBA|0 Comments

VBA code to check if active cell is blank

VBA to check if an active cell is blank macro will help us to determine whether an active range is filled with some value or not. This example will help us to know how to check if an active cell or a range is blank or not using Excel VBA. This can be used in

By |January 20th, 2015|VBA|0 Comments

VBA code to check if a cell is blank

We can use VBA to check if a cell is blank and run the remaining statements. Sometimes, we need to determine and make sure a particular range is not empty before proceeding to the next statements. This example will help you to know how to check if a cell or a range is blank or

By |January 20th, 2015|VBA|1 Comment

VBA write to text file without carriage return Excel

VBA write to text file without carriage return Excel Macros Examples for writing to text files using VBA in MS Office Word, PowerPoint, Access, Excel 2003, 2007, 2010, 2013 and VBScript. This Example VBA Program and function will help you to know how to write a string to text file using Excel VBA. Writing to

By |January 19th, 2015|VBA|0 Comments

VBA write to text file new line Excel

VBA code to write to text file new line Excel Macros Examples for writing to text files using VBA in MS Office Word, PowerPoint, Access, Excel 2003, 2007, 2010, 2013 and VBScript. This Example VBA Program and function will help you to know how to write to text file in New Line using Excel VBA.

By |January 19th, 2015|VBA|0 Comments

VBA write to text file line by line Excel

VBA code to VBA write to text file line by line Excel Macros Examples for writing to text files using VBA in MS Office Word, PowerPoint, Access, Excel 2003, 2007, 2010, 2013 and VBScript. This Example VBA Program and function will help you to know how to write to text file line by line using

By |January 19th, 2015|VBA|0 Comments

VBA write to text file carriage return Excel

VBA write to text file carriage return Excel Macros Examples for writing to text files using VBA in MS Office Word, PowerPoint, Access, Excel 2003, 2007, 2010, 2013 and VBScript. This Example VBA Program and function will help you to know how to write a string to text file using Excel VBA. Writing to a

By |January 19th, 2015|VBA|0 Comments

VBA write to a text file Excel

VBA write to a text file Excel Macros Examples for writing to text files using VBA in MS Office Word, PowerPoint, Access, Excel 2003, 2007, 2010, 2013 and VBScript. This Example VBA Program and function will help you to know how to write a string to text file using Excel VBA. Writing to a text

By |January 19th, 2015|VBA|0 Comments

VBA write to a text file with quotes Excel

VBA write to a text file with quotes Excel Macros Examples for writing to text files using VBA in MS Office Word, PowerPoint, Access, Excel 2003, 2007, 2010, 2013 and VBScript.This Example VBA Program and function will help you to know how to write a string to text file with quotes using Excel VBA. Writing

By |January 19th, 2015|VBA|0 Comments

VBA write to a text file from Excel Range

VBA code to write to a text file from Excel Range Macros Examples for writing to text files using VBA in MS Office Word, PowerPoint, Access, Excel 2003, 2007, 2010, 2013 and VBScript. This Example VBA Program and function will help you to know how to read the data from excel and write to text

By |January 19th, 2015|VBA|19 Comments

VBA write text file append

VBA code to VBA write text file append Excel Macros Examples for writing to text files using VBA in MS Office Word, PowerPoint, Access, Excel 2003, 2007, 2010, 2013 and VBScript. This Example VBA Program and function will help you to know how to write to text file for appending using Excel VBA. Writing to

By |January 19th, 2015|VBA|0 Comments

VBA write string to text file without quotes

VBA write string to text file without quotes Excel Macros Examples for writing to text files using VBA in MS Office Word, PowerPoint, Access, Excel 2003, 2007, 2010, 2013 and VBScript. This Example VBA Program and function will help you to know how to write a string to text file without quotes using Excel VBA.

By |January 19th, 2015|VBA|0 Comments

VBA to append a text file Excel

VBA code to VBA to append a text file Excel Macros Examples for writing to text files using VBA in MS Office Word, PowerPoint, Access, Excel 2003, 2007, 2010, 2013 and VBScript. This Example VBA Program and function will help you to know using VBA to append a text file using Excel VBA. Appending a

By |January 19th, 2015|VBA|0 Comments

Related pages


hlookup in excel exampledata types vbaexcel vba formula arrayhow to adjust columns in excelhow to remove duplicate data in excel 2010excel and vba tutorialautomation testing interview questions and answers pdf free downloadexcel color duplicatesexcel vba functionmessage box vba accesshow to make macros in excel 2007vba excel open text fileexcel vba form controlsexcel vlookup nahow to create checkbox in excelvba code snippetsvbscript code examplesaccess vba msgboxexcel dashboard template freeexcel macro break loopexcel 2003 find duplicatesuseful macros excelcreating an excel macroascending order in excel 2007vba programming examplessumif excelrefresh all pivot tables vbavb programs examplespivot table descending orderaccess vba sqlexcel vba activex controlsdelete all empty rows in excelvb 6.0 interview questions and answers for experiencedrow vbavba excel open filevba excel selectexcel vba macro buttonamazing excel formulasvba excel countifvba case sensitivesql update vbacheckbox vba excelexcel 2010 nested if statementsvba macros for beginnerssql dml queriesexcel 2007 concatenatebeginners sqllocking formulas in excel 2010excel option button valueunlock password excelremove hyperlink excelhow to use data validation in excel 2013sql manipulation commandsvlookup demomerge and center the selected cellsexcel colorindexexcel macro copy data from one workbook to anothermerge & center the selected cellshow do i insert a column in excelformula for adding columns in excelexcel graphing tutorialdashboard formats in excelhow to pivot table excel 2010excel vba datesexcel bar graph templatesremove hyperlinks in excel 2007xml convert to excelexcel formula for colour of cellmicrosoft excel dashboard templatesexcel what if statementsexcel vba text boxexcel macro repeatfor loop vbahide column vba