Type Mismatch Error in VBA

I made a macro that would copy data from two vertical collumns into a more organized table. However, the program keeps outputting a type mismatch error. The funny thing about this error is that its marking my declaration of "sub preformat" as the error. When I attempt to put breakpoints the code never advances beyond this first line. What is the problem? (When I revert back to an earlier version of the code, the problem does not exist, but as soon as I paste the remaining code, I get an error). I am absolutely baffled.

Please Login or Register  to view this content.

The easy and best way to trouble shoot this problem is to;

1. at the point of the error dialog, click on debug.
2. the highlighted code will need to be examined for values and operations.
3. with the type mismatch errors, the value of data(from cells) matters.


You have options for fixing this.
1. Fix it yourself.
2. Have me fix it for you(post the workbook).
3. Setup a remote session(with Join.Me) and a phone call to show you the steps required for trouble shooting this problem.

My advice to you is:
Learn how to use the debugger.

A few problems

This line is nonsense

For N = 1 To 14 Then

the Then is superfluously wrong.

Then you try to use an array currRow2 as the row number in a range, which makes no sense, but you also store 2 in every element of that array, so why bot just use 2?

I think I see what you intend, this should fix it

Please Login or Register  to view this content.