Any help would be appreciated on this as I am not an Excel\VBA programmer. I use SPSS daily at work which frequently results in generating excel SS's.
I have a large table with cell counts of less than 5 and SPSS allows one to generate an excel table with the following text if the cell count is below five "<5".
All I need to do is find each cell containing <5 and simply clear the contents of the 3 cells above it and leave the "<5" string in place.
For what its worth (trying not to be too lazy)I managed to figure out the code to insert a blank line after "Totals" in the table but this issue with "<5"
is too perplexing
. Any help would really be appreciated.
I have a large table with cell counts of less than 5 and SPSS allows one to generate an excel table with the following text if the cell count is below five "<5".
All I need to do is find each cell containing <5 and simply clear the contents of the 3 cells above it and leave the "<5" string in place.
For what its worth (trying not to be too lazy)I managed to figure out the code to insert a blank line after "Totals" in the table but this issue with "<5"
is too perplexing
