Invoke a business rule for an array?

Summary

Invoke a business rule for an array?

Content

Hi,

PBCS

in the same way that you can invoke a business rule from a form and have a business rule that launches on save which uses the values in the form, is it possible to do the same from an ad-hoc grid in Smart View, but responding to an array of values?

i.e.

Business Rule

Fix ({CostCentreArray},{EntityArray})

Excel;

CostCentreArray =  A5:A(last populated value in spreadsheet)

Entity= B5:B(last populated value in spreadsheet)

The only way I can think of is to invoke this in a loop via Visual Basic in excel, calling the script for each row, but is massively sub-optimal, so I wonder if there was anyway better?