Find And Replace String Using VBA Code
There are several ways to replace string using VBA code, by looping each cell or by using VBA Replace function. Let's say that we want to replace "Macros... [read more]
VBA Select Case - Using VBA Select Case Statement in Excel
The VBA Select Case Statement is an important construct in the VBA language. The Select Case statement in VBA allows the program to execute one set of statement... [read more]
Excel VB userform creation
I have been tasked to create a project with vb/excel. I am doing a very basic insurance quote system. I have already designed the user forms I just need the cod... [read more]
Control Chart in Excel Using VBA - Six Sigma Control Chart Code & Software
In Six Sigma Control charts using Excel we saw how to make control charts using named ranges. From there on, it was a short hop to porting the logic to VBA. So ... [read more]
Treemap in Excel - Coming Soon
Its been a few days since I posted. In case you were wondering what I was up to – yours truly was busy coding a program to create treemaps in Excel. Treemaps ... [read more]
Excel 2003 Style Menu in Excel 2007/2010
I really don't want to write this article as I'm in love with new interface of Excel 2007 and wants my blog readers and every excel user to understand the new R... [read more]
Highlight Duplicates in Excel
sometime we have to highlight Duplicates in excel and later work on them rather then deleting them using option " Remove Duplicates " . here we will use " Condi... [read more]
NEED BASIC EXCEL REPORTING SHEET MAYBE VBA / MACRO
HI HERE IS THE PROJECT. MY BOSS HAS +/- 40 SHOPS. THERE ARE +/- 11 MANAGERS. EACH MANAGER MANAGES +/- 2 TO 5 SHOPS. EVERY WEEK MY COLLEAGUE RECEIVES ... [read more]
Need excel macro to delete title rows in last page in print
Need an excel macro expert to suppress/delete the printtitle rows in the last page of excel spreadsheet while printing/print preview Hi, I need either an ex... [read more]
Very Simple Job Excel - Vba - Macro
Very simple job Excel - VBA - Macro - Visual Basic - VB Please see the attached spreadsheet with all details. Thanks Related posts:Looking For A Developer... [read more]
SHRINK REDUCE EXCEL FILE SIZE
If minor or little changes in your excel workbook bloated its size to 200% and above then it's a serious issue but not worry issue as it has solution.Understand... [read more]
3 Things to remember before Excel VBA Job Interview
Like giving interview is a skill, taking interview is another great skill. Ashish Jain have taken many interviews in the past and given more than he has taken a... [read more]
Break the text in 1 excel column into 3 columns
Break the text in 1 excel column into 3 columns as per the example shown in the spreadsheet. I need to be able to do this again with another spreadsheet so you ... [read more]
Treemap in Excel - Coming Soon
Its been a few days since I posted. In case you were wondering what I was up to – yours truly was busy coding a program to create treemaps in Excel. Treem... [read more]
Multithreaded VBA - An Approach To Processing Using VBScript
Today’s guest post is authored by Daniel Ferry, a longtime professional Excel developer and consultant (and a newbie blogger). A few months ago, I wrote a pos... [read more]
Next >