Hi,
I need to have a VBA code that looks at rows in a range and gives back the number of rows which contain text in any of their cells (only text not numbers).
For example for range(B3:H10) if there is text in cells C3, F3, D9, G10, H10 then the number I should get is 3 because we have text in row B3:H3, in row B9:H9 and in row B10:H10.
The result can be found in cell A2.
How would I do that?
Thanks,
Nic
I need to have a VBA code that looks at rows in a range and gives back the number of rows which contain text in any of their cells (only text not numbers).
For example for range(B3:H10) if there is text in cells C3, F3, D9, G10, H10 then the number I should get is 3 because we have text in row B3:H3, in row B9:H9 and in row B10:H10.
The result can be found in cell A2.
How would I do that?
Thanks,
Nic