Hi everyone,
I am using VBA to count cells that meet a certain criteria, in this case, cells that contain underlined values/text. The purpose of the script is to provide a reference that will be used in later calculations. The problem is that the current script also outputs zeros, which will effect future calculations. The obvious solution would be to create a new column and blank the cells with a value of zero. However, I will be applying this script to a large number of worksheets so would like to make it as simplified as possible, without having to do any additional modifications to the data after the script has run.
The current script is:
I need help in modifying the script so that any calculated zeros are removed.
Cheers!
Bookmarks