Find macro refinement in row

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.

+4
1

, Row

.

() .

, :

Dim rng As Range
Set rng = Range("A1").EntireRow

A) C) , A, B) ( A).

:

Range("B" & TOS & ":B" & TOE).Select

":" ( ). ( , .)

, :

Range("A1").Delete xlShiftUp
+4

Source: https://habr.com/ru/post/1541907/


All Articles