function that will return a cell referen

Within Excel if you want to find the last row that has data you will need to write a macro that will walk down a column evaluating the data until you come to the cell you are looking for, check out the ActiveCell property of the worksheet. If the cell you want is in the same place every time then your life is a lot easier you can use the Range or Cell property of the worksheet. The below code is an example of a macro used to walk down a column evaluating each cell and Capitalizing the contents of the cell:

Sub Set_Cap()
Dim intC As Integer

ActiveSheet.Range("A1").Select

intC = 1
While intC = 1
ActiveCell.Value = UCase(ActiveCell.Value)
ActiveCell.Offset(1, 0).Select 'Down 1
If ActiveCell = "" Then 'No More Data
intC = 2
End If
Wend

MsgBox "Done"

End Sub

If you have any other questions let me know.

Good Luck

Neal Martinelli

The easiest way to go to the last row is Ctrl+End, which will take you to the last cell in the sheet.

This question was auto closed due to inactivity