All posts tagged "Excel VBA Macros"

  • excel vba how to find last row with data

    How To Find The Last Row In an Excel VBA Range 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...

    • Posted March 22, 2017
    • 2
  • how to copy range of cells in excel using 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...

    • Posted February 2, 2017
    • 2
  • Code Execution Has Been Interrupted – How To Fix That Annoying VBA Error

    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 interupted macro processing with the message...

    • Posted January 3, 2016
    • 26
  • VBA Class Module Example – Better VBA With Objects

    What is object based coding in VBA? Learn what VBA Class Modules are used for, and how to massively improve your vba by writing your own custom classes.

    • Posted October 27, 2015
    • 18
  • How To Automate Tasks With Microsoft Excel VBA

    Microsoft Office uses VBA as it’s macro or programming language. If you would like to learn to automate tasks with Excel VBA check out the video below and read this article. This video and article will give...

    • Posted February 13, 2014
    • 3
  • VBA Programming Tutorial – Using Functions and Subroutines

    So you have started to write vba code but you are not quite sure if you are doing it correctly, or if you are “on track” to write professional quality macros.Why even bother to write pro quality...

    • Posted January 30, 2013
    • 1