Auto invoke of a VBA Sub function
Thnaks, Bill. I don't quite understand the last sentence. Do you mean one
would have to
do a keyboard action to distribute the array?
Ed
You could call your Sub procedure from the Worksheet_Calculate event
(taking
care to avoid a recursive loop by using Application.EnableEvents = False).
But you would probably be better to remake it as a Function which takes
the
input cells as arguments and returns the results as an array. Then
array-enter the function call into the output cells (using
Ctrl+Shift+Enter).
Bill Manville
|