Hello,

We appreciate if anybody can help me to wrote a macro to copy a formula to a
ong range:

This is my worksheet layout more or less:

A B c
1
2
3
4
5.
..
..
..
..
I want to copy a formula in cell C4 tp range C7 upto C65000

maybe it is simple, but since my background is accountancy so I really do
not know how to make it.

Since the range will be dynamic, but it is difficult to make it, if possible
it prompts us to fill in from C7 to C.......( dots means it prompts us to
fill in celll of column C.

Thanks in advance for any idea.



--
H. Frank Situmorang