Tags » Vba

VBA Excel - Delete Blank Rows to Move Up Data

If you are like me and other Excel users who have to to clean up data after deleting contents, you must be tired of using your mouse to select blank rows and then right-click your mouse to delete them.  434 more words

Microsoft Excel

Find The Last Row or Column on a Sheet

If you know the column with a value on every used row use the below to determine the last row on the sheet.


Sub LastRow() 64 more words

Event Analysis in Excel/VBA

Today we wanted to show a quick and easy implementation of event analysis in excel. The literature on this topic is large with most of the research concentrating on the stock market. 994 more words


Excel Hovering Copy! || No Clicks Needed!!

How is it going Excel users?  Still loving Microsoft Excel at this point and only hate it a little?  Then, keep on reading this article about a new type of copy feature that I have created via the VBA background in Excel. 536 more words

Historical Analogs/ Time Series Clustering in Excel

A very useful approach to analyzing price action of a particular security is to search historical instances where price exhibited similar behaviour. This type of analysis has often been called historical analogs by some writers. 991 more words


Tricks at SmartView upgrade from to

Today, let us talk about SmartView. For this tool, the deployment or configuration is always a headache to administrator. You need to provide a very detail document with screen captures about the installation steps. 663 more words