Can this code work with multiple sheets in one workbook

I applied this wonderful code (see link) to my first worksheet in my workbook - and it works fantastic - thank you so much for making this available to the public.
However, I thought I could just copy and adjust this code for other cells in my other worksheets - within the same workbook - and it would continue to work perfectly.
But it didn't. I get a run time error now - is there something else that needs to be done to make this code work for multiple sheets in one workbook?

Originally Posted by clbutler2008

I applied this wonderful code (see link) to my first worksheet in my workbook - and it works fantastic - thank you so much for making this available to the public.
However, I thought I could just copy and adjust this code for other cells in my other worksheets - within the same workbook - and it would continue to work perfectly.
But it didn't. I get a run time error now - is there something else that needs to be done to make this code work for multiple sheets in one workbook?

Still no code in the workbook