I believe the macros are not working on all the tabs, You helped and sent
me a macro in a practice book i tweaked them and applied them to my working copy and if I got any number besides "0" then i thought it worked, but apparently I was mistaken. It appears as though the macros work to some extent then they stop going down to next row. Maybe a break in data some of my tabs have the rows that have no data but a concatenate function and nothing. Do the macros know when they are at the bottom of the rows with data. Some tabs from previous post are not detection any data at all? Idunno! Thanks for all your help