I have 3 workbooks (a, b, c) each containing some data in a worksheet
the data is a table format i.e continious rows and columns)
1) I need to copy the data of a, b and c in such a way that the table of b is copied two rows below the row where table a ends. and table of c is copied two rows below where table of b ends.
So at the end of this excercise i will have 3 tables one below the other in the nex xl sheet d.
The code will be executed from outside excel. the dimentions of the table has to be calculated at runtime.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.