Have you looked at the autofill method?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Constantinos Kozakou" wrote in
message ...
I have use the Sumif function in VB using VB code. How
can I copy this function for a number of cells without to
rewrite the code.