Mar 06 2022 06:54 PM
Mar 07 2022 03:42 AM
Option 1:
Instead of Paste Values, select the range with formulas and run the following macro (I have assigned it to a Quick Access Toolbar button for ease of use):
Sub Formulas2Values()
On Error Resume Next
Selection.Value = Selection.Value
End Sub
Option 2:
Instead of COUNTA, use SUMPRODUCT:
=SUMPRODUCT(--(range<>""))
Mar 12 2022 05:53 AM