OK, I can see that there are no reply's so what if the requirement will stay same apart of the table I have mentioned before. So instead of having table the selection will be made in VBA prior starting the macro... ( So everything will be set behind in code) Hope it make sense...