One other pointer for somebody who doesn't know VBA BASIC. the "WITH"
statement is used to combine function that have a DOT infron of them


With Worksheets("Old sheet")
DataA = .Range("A" & OldRowCount)
end with

Is really
DataA = Worksheets("Old sheet").Range("A" & OldRowCount)

This feature of BASIC doesn't translate well to C++

" wrote:

Ah okay joel,

I am used to C++ and Java where != is not equal to. VBA newbie
indeed.

I now understand how it works. Thanks for the demonstration, it is
certainly a great building block.
Ill let you know how far i get before i get dizzy.

thanks.