Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: how to use VBA codes to get the information of last used cel

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Singapore
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    say i need to get the row number of the last used cell in column A. And also need to trap the information of column C in the same row. All these are in VBA codes. Not Match or VLOOKUP in spreadsheet.

    thx for help

  2. #2
    Guest

    Default

    say i need to get the row number of the last used cell in column A. And also need to trap the information of column C in the same row. All these are in VBA codes. Not Match or VLOOKUP in spreadsheet.
    How about this?

    Function LastCellInColumn(ColNumber As Integer)
    LastCellInColumn = ActiveSheet.Cells(65536, ColNumber).End(xlUp).Row
    End Function

    HTH,
    D

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Singapore
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thx! This may be a good one. I will use it if can't find better ones.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •