as I expected- it was a forlorn hope
We are looking at changing the layout in VB so that we can use a value in the column in another column (i.e. copy the value over as an input as opposed to a formula). So far it works as an excel copy and paste, then copying the values back- our resident VB expert is still on a learning curve, although i am gradually catching up!