sorry, how do you mean a worksheet function. i kind of need to this automatically for each sheet. any ideas?