lunes, 29 de diciembre de 2025

EXCEL MACRO LINDERO()

 Sub LINDERO()
Dim a As String
    Sheets("LOTE").Select
    a = Range("G2")
    Workbooks.Open "C:\Users\USER\Desktop\ALFAPLANO.xlsx"
    Sheets("PLANO").Select
    ActiveSheet.Shapes.Range(Array(a)).Select
End Sub

EXCEL limpiacalc()

Sub limpiacal()
Dim Resp As Byte
    Range("N222").Select
    ActiveCell.FormulaR1C1 = "0"
    Range("N209:N222").Select
    Selection.FillUp
    Range("N209").Select
End Sub

EPMAPASD

 Consultadeudaporcedula

CITACIONES

 VEHICULOS

MAPA SANTO DOMINGO-MALLA URBANA

 MALLA URBANA

MAPA SANTO DOMINGO-GOOGLE MAPS

Google Maps

CNEL UBICACION MEDIDORES

 


Geoportal

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