I am using the following code to enter the automatic list numbers
[B7:B10].Formula = "=IF(C7<>"",COUNTA($C$7:C7),"")"
but its giving me the error
Runtime Error 1004
Application Defined or Object Defined Error
Help will be appreciated
Regards
Mazher
[B7:B10].Formula = "=IF(C7<>"",COUNTA($C$7:C7),"")"
but its giving me the error
Runtime Error 1004
Application Defined or Object Defined Error
Help will be appreciated
Regards
Mazher