I have looked at several threads regarding finding the last row / cell in a spreadsheet using a macro, and I have a few questions.
First, does the following code return only a row value or an integer cell value ("1" or "A1")?
Dim TOS As Long
TOS = Range("A1").Row
As an alternative, besides the obvious (the fact that they start from the bottom and find the last cell plus 1), is there a difference between these other codes (in how they will display or retrieve their data)? I just need the simplest (or best if you have a good argument) to return only the row (not the cell).
and.)
Dim TOS As Long
TOS = Range("A65536").End(xlUp).offset(1,0).Row
B)
Dim TOS As Long
With Application.Workbooks("Test").Sheets(1)
If WorksheetFunction.CountA(Cells) > 0 Then
TOS = Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
End If
C.)
Dim TOS As Long
TOS = Range("A65536").End(xlUp).Row + 1
, , , , . , . " ". , , , . , " ", , , , , , , , .
-, , , (), , ,
.)
Range("B" & TOS:"B" & TOE).Select
TOS TOE - , B.