You are adding data on a consistent basis to your spreadsheet, and you need to have a macro that references the last row that was just added to your Excel spreadsheet data range or table. This article and associated video will show you how to do just that. Fig 1 So similar to "Fig 1" above you would like to reference row 14 of the table and possibly iterate over each … [Read more...] about How To Find The Last Row In an Excel VBA Range
Programming
How To Resize A Named Range In Excel VBA
To resize a named range in Excel VBA it's best to get an object reference to the range and then use the Excel VBA resize method to resize the range. With the resized range object you then set it's name property to the range name that you want resized. Excel will behind the scenes delete the old range name and replace it with the one you have just created. The spreadsheet … [Read more...] about How To Resize A Named Range In Excel VBA
How To Copy A Range Of Cells In Excel Using VBA
There are many ways to achieve the same objective in Excel, in this instance copying a range of cells to a new spreadsheet location. The spreadsheet above represents the situation after the code has been executed. Before execution the range "F1 through "H6" would not contain any data. In this example I will copy the cells in vba by creating a range … [Read more...] about How To Copy A Range Of Cells In Excel Using VBA
Python Create CSV Text File From Tab Delimited
In this tutorial video, I take a file downloaded form a website that is tab delimited and convert it to a comma delimited csv file using a python program that can be called from the command line.This csv file will be imported into LibreOffice base (Free database software for Mac, PC or Linux) for further processing. If you program or write macros in a … [Read more...] about Python Create CSV Text File From Tab Delimited
Code Execution Has Been Interrupted – The best fix to this Excel VBA Problem
I first came across this Microsoft Excel vba error back in 2009, when the vba dialog box interrupted macro processing with the message "Code Execution Has Been Interrupted" and it quite literally did my head in.It's a weird error because it doesn't have an error number and in fact it isn't really an error but rather a bug for which a lot of misinformation existed on … [Read more...] about Code Execution Has Been Interrupted – The best fix to this Excel VBA Problem