how to use VBA codes to get the information of last used cel
Eliminate Pivot Table Annoyances
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.

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
  •  

 

 
DMCA.com