I am having a problem moving the code to my app.

When I try to compile it comes up "argument not optional" on Set Pool = poolList.Item(J) - it does not like "Pool"

Note I am calling this from a multisheet app - so I have changed all the "Sheet1" to wks (wks as worksheet) as this is what my app uses.

Any help would be greatly appreciated.

I have put the code in a blank wkbk cause my app is huge

Ta,
Martin

Attached Files

wksCodeError.xlsm (19.4 KB, 517 views)