Defining Arrays help

[kevincoxshall]

Evening all

I am using VB code to perform this function successfully

Please Login or Register  to view this content.

What I would like to do is change b1:b10 to say e1:e10 by defining the column values to a variable.
The code below is what I would like to do....

Please Login or Register  to view this content.

I have tried lots of variations with no joy. I know "array" is not allowed after Dim statement.
Do help if you can

Ta

Kevin
Jersey

[PCI]

Take care, inside in the EVALUATE function is a string, try next code
NOT TESTED

Please Login or Register  to view this content.