Visor Member Mar 24, 2016 #1 Dear friends of the forum, what I want to accomplish is to place numbers in advance as in order to be counting the cells that contain data. I get using formule o but wit macros not Please can you help me? I upload the file to be seen Thank you Attachments Contar solo celdas con contenido.xlsm Contar solo celdas con contenido.xlsm 17.3 KB · Views: 5
Dear friends of the forum, what I want to accomplish is to place numbers in advance as in order to be counting the cells that contain data. I get using formule o but wit macros not Please can you help me? I upload the file to be seen Thank you
Chihiro Excel Ninja Mar 24, 2016 #2 So you are just trying to count number of cells in Column C that contain data? What is your expected output?
So you are just trying to count number of cells in Column C that contain data? What is your expected output?
John Jairo V Well-Known Member Mar 24, 2016 #3 Hi @Visor (and @Chihiro) What about this code: Code: Sub Num() With Range("D2:D" & Range("A" & Rows.Count).End(xlUp).Row) .Formula = "=IF(C2="""","""",1+MAX(D$1:D1))" .Value2 = .Value2 End With End Sub Blessings!
Hi @Visor (and @Chihiro) What about this code: Code: Sub Num() With Range("D2:D" & Range("A" & Rows.Count).End(xlUp).Row) .Formula = "=IF(C2="""","""",1+MAX(D$1:D1))" .Value2 = .Value2 End With End Sub Blessings!
Visor Member Mar 24, 2016 #5 Excellent!!!! I just tried to use macro instead of formulas, this solution is magnified thanks for your help Topic solved
Excellent!!!! I just tried to use macro instead of formulas, this solution is magnified thanks for your help Topic solved
