Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lastrow function
Given this function:
Function LastRowByRow(sh As Worksheet) On Error Resume Next LastRowByRow = sh.Cells.Find(What:="*", _ After:=sh.Range("A1"), _ Lookat:=xlPart, _ LookIn:=xlFormulas, _ SearchOrder:=xlByRows, _ SearchDirection:=xlPrevious, _ MatchCase:=False).Row On Error GoTo 0 End Function How would I go about changing this to a specific column instead of the entire worksheet? Example of how it's called now: Sheet7.Range("D" & LastRowByRow(Sheet7) + 1).Value = NewEntry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lastrow - function not defined | Excel Discussion (Misc queries) | |||
Assistance with LASTROW function in VB | Excel Programming | |||
LastRow function - #VALUE | Excel Programming | |||
'LastRow' Function not working | Excel Programming | |||
Go to lastrow using other column's lastrow | Excel Programming |