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