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

Andrew XJ · Mar 6th, 2002, 05:42 AM

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

Mar 6th, 2002, 05:53 AM

Quote:

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 · Mar 6th, 2002, 06:35 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 05:42 AM	#1
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	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

Mar 6th, 2002, 06:35 AM	#3
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	Thx! This may be a good one. I will use it if can't find better ones.