Counting characters of each cell and printing the result to another worksheet

hello, I have a program here that deletes a row which contains the values "PLC" and "BFT", but now I have to change it and instead of deleting these rows, I need to be able to Count the characters in these particular rows.

the problem is, I'm not entirely familiar on how to count the characters in each cell, and then paste the result in another worksheet.

here is my sample code.

Please Login or Register  to view this content.

notice that rows with the BFT and PLC values reach until Column T. I need to count the number of characters in each of those columns from Column A to Column T and then print their result to another worksheet, lets say worksheet2.

Thank you

Try this

Please Login or Register  to view this content.

I'm not to sure from your description of the problem if this is what you are trying to do.