lunes, 29 de diciembre de 2025

EXCEL SUMA WorksheetFunction Columns Rows.Count



Dim ufil As Integer

Dim pcol As Integer

Dim ucol As Integer

Dim sum As Integer

pcol = Range(Selection.Address).Column

ucol = Range(Selection.Address).Column + Selection.Columns.Count - 1

pfil = Range(Selection.Address).Row

ufil = Range(Selection.Address).Row + Selection.Rows.Count - 1

a = Range(Cells(pfil, pcol), Cells(ufil, ucol))

sum = Application.WorksheetFunction.sum(a)

MsgBox "suma: " & sum

End Sub

No hay comentarios:

Publicar un comentario