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

[Andrew XJ]

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

 

[Guest]

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

 

[Andrew XJ]

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