ExcelBanter - Worksheet Function using VB code

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Worksheet Function using VB code (https://www.excelbanter.com/excel-programming/307733-worksheet-function-using-vbulletin-code.html)

Constantinos Kozakou

Worksheet Function using VB code

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.

Bob Phillips[_6_]

Worksheet Function using VB code

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.

All times are GMT +1. The time now is 06:01 AM.