Hi Dennis,

I understand your confusion with the function. Let me explain it to you in detail.

The function is used to find the last used cell in a column. In your code, you are using it to find the last used cell in column A. The after the function is used to move one cell down and one cell to the right of the last used cell in column A.

So, in your code, the refers to the first empty cell in column A. This is where you are trying to enter the value "Test".

However, there is a mistake in your code. You are trying to assign the value "Test" to the property of the cell inside the With statement. This is not the correct syntax. You should first select the cell and then assign the value to it.

Here's the corrected code:

1. Sub Test()
2. With Sheets("Sheet2")
3. .Cells(.Rows.Count, 1).End(xlUp).Offset(1, 0).Value = "Test"
4. End With
5. End Sub

In this code, we first select the worksheet "Sheet2" using the With statement. Then, we use the property to refer to the last used cell in column A using the and functions. We then use the function to move one cell down from the last used cell and assign the value "Test" to it.

I hope this helps you understand the function better.