Excel Help

tcpik

Well-known member
  • Oct 11, 2007
    2,183
    89
    48
    http://hollywoodvfx.blogspot.com/
    Can I Add A Sequential Number To A Spreadsheet Each Time It Is Opened?

    Machan meka mata Team Viewer connect wela karala denna puluwanda code ekakth thiyenawa

    Sub AUTO_OPEN()

    Range("A1") = Format(Range("A65536"), "YYYYMMDD") & Format(Right(Range("A1"), 3) + 1, "000")

    End Sub