Hi
why do you want to use VBA and not a simple formula?

--
Regards
Frank Kabel
Frankfurt, Germany
"Metin" schrieb im Newsbeitrag
...
Hi all,

I have a worksheet with 18 columns. Each column has a lot of data, and
each
time I have various number of data. The number of data can be between 200
and
5000 in one column. The number of data in each column is always equal.The
data starts at row 2, because row 1 is always the title.
I want to subtract the data from column J with data from column F, and the
results I want to put in a new sheet, called "calculate data" in Column F.
Could somebody tell me how to do this with VB.

Thanx,
-Metin-