If worksheet :
A B C
1 20051208 =LEFT(A1,6) 10000
2 20051209 5000
3 20051222 24200

I want to copy the formula from cells(B1) down to the last used cells(which
is unknown) , how to implement in VB. I try to use OFFSET but doesn't work.

Thanks for your help in advance